Hello,
I want to create UserForm with ComboBox in which there will be list of integer numbers from 1 to i (where 'i' is variable counted by other function)
e.g. i = 6, so on the ComboBox list there will be: 1, 2, 3, 4, 5, 6.
Also I would like to prompt message if user will write in ComboBox something outside of the list. Can anyone show me direction how can I do this?
Thanks for help!
For a combobox named combobox1
Change the combobox MatchRequired property to True for second point.
Please Login or Register to view this content.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
I've found another solution but thanks anyway!
Glad you could solve your issue. May be you can post the solution you found here for others benefit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks