Thread: Listbox Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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