| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Value
This has to be easier than I'm making it. I have two Listboxes on a form. I
want to combine the input from the listboxes to create a single value. For instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" & Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and neither work. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox Value
MyValue = ListBox2.Value & "_" & Listbox3.Value
Didn't work? StephanieH wrote: This has to be easier than I'm making it. I have two Listboxes on a form. I want to combine the input from the listboxes to create a single value. For instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" & Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and neither work. What am I doing wrong? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox Value
Ugh. So close, and yet so far.
Thanks Dave. "Dave Peterson" wrote: MyValue = ListBox2.Value & "_" & Listbox3.Value Didn't work? StephanieH wrote: This has to be easier than I'm making it. I have two Listboxes on a form. I want to combine the input from the listboxes to create a single value. For instance if the value from Listbox2 is "2005" and Listbox3 is "03" I want my value to be "2005_03". I've tried MyValue = " & ListBox2.Value & "_" & Listbox3.Value & " and MyValue = ListBox2.Value "_" Listbox3.Value and neither work. What am I doing wrong? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| Modification of listbox to listbox code | Excel Programming | |||
| Multicolumn Listbox and ordinary listbox | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
