View Full Version : list box
darkrider
03-07-2007, 04:11 PM
hey can someone help!!
is their any way..you can do calculations from a list box..
ie.if u have a list box..with inputted data.can you do a calculation from the list box to an output text box
Bob Phillips
03-07-2007, 04:25 PM
Do you mean something like
TextBox1.Text = ListBox1.Value * 10
darkrider
03-07-2007, 04:32 PM
thanks..
whitewidow
03-09-2007, 02:11 PM
how does this work if you have about 7 values in a listbox
Bob Phillips
03-09-2007, 02:54 PM
One is selected?
whitewidow
03-09-2007, 02:57 PM
does it have to be selected, would it not work if it was not selected and is there a way to get it to work with out selection anything
Bob Phillips
03-09-2007, 03:10 PM
Not with the code I gave, because .value refers to the selected (only selected) item in the listbox.
whitewidow
03-09-2007, 03:17 PM
so how would it be done if not to be selected
Bob Phillips
03-09-2007, 03:27 PM
I don't see how you can, how would you know which item within the listbox to work with?
whitewidow
03-09-2007, 03:29 PM
would this be done in a textbox
Bob Phillips
03-09-2007, 03:46 PM
Would what be done in a textbox?
whitewidow
03-10-2007, 04:06 AM
is there any chance that output from excel be done in a textbox, but with about 10 values in to one textbox
mdmackillop
03-10-2007, 09:15 AM
This is probable.
whitewidow
03-10-2007, 11:10 AM
not quite sure how it is possible
lucas
03-10-2007, 11:39 AM
post your workbook with explainations....I don't think we understand what your trying to do.
mdmackillop
03-10-2007, 11:48 AM
not quite sure how it is possible
...the impossible taks a little longer.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.