PDA

View Full Version : Need Help on Userform



rbagri
06-27-2009, 07:54 AM
Hi I have a userform and I want to put a multiple entry conrol on it. for example On vehicle repair invoice it should be able to take many parts at a time.
I know about spreadsheet control but I think it is not availble on Office 2007.
Can any body suggest other alternative.
Thanks

p45cal
06-27-2009, 09:03 AM
A list box or Combobox with multiselect perhaps?

rbagri
06-27-2009, 09:56 AM
That will not work in my case beacuse there is no parts database you put it manully there could be million of parts

Aussiebear
06-27-2009, 03:00 PM
What about multiple text boxes?

Simon Lloyd
06-27-2009, 03:10 PM
simply use a textbox to populate a textbox or listbox, so enter a value in Textbox1 click your command button and add the value to the 2nd textbox, something like:

Sub Commandbutton1_click()
Me.Textbox2.value = Me.Textbox2.Value & vbnewline & Me.Textbox1.Value & vbnewline
Me.textbox1.value=""
End Sub
not tested obviously but you get the idea!