Hi,
I have a Userform and would like to be able to put a number between 1-50 in a TextBox then click the "ADD" button and it add a prefix of AA to the number then display all the numbers in a ComboBox/drop down list.
e.g. Put the number "10" into the text box then click a Button call "ADD" i then want to see "AA1" in the 1st line, "AA2" in the second line all the way to "AA10" in the ComboBox/drop down list
Can this be done?
TIA
See if this gets you close.
David
(*) Reputation points appreciated.
Hi Tinbendr,
Sorry for the delay in my reply, Wow thank you very much this is perfect!
Is there any way to stop it adding the same line over and over (e.g. if you type No.1 then the No.2 i get a repeat of number 1)
TIA
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Perfect, Thank you very much for your help.
You're welcome.
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks