PDA

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.