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
A list box or Combobox with multiselect perhaps?
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
That will not work in my case beacuse there is no parts database you put it manully there could be million of parts
What about multiple text boxes?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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:
[VBA]
Sub Commandbutton1_click()
Me.Textbox2.value = Me.Textbox2.Value & vbnewline & Me.Textbox1.Value & vbnewline
Me.textbox1.value=""
End Sub
[/VBA]not tested obviously but you get the idea!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote
