I have a listBox on a UserForm. Its RowSource is a list of Budget Years.
It is important that the correct year is selected by the user. I want to get a message box to warn a user that he has not selected a year.
I have tried versions of the following code without success.
This does not work, yet the unselected value of the Listbox is null.
Please Login or Register to view this content.
How should I refer to it to make my code work?
John
What happens if you try If Me.LBYear.Value = ""?
John
You can check if a user has selected an item from the list in a single select listbox by looking at its ListIndex property.
If that is -1 then they haven't selected an item, if it's 0 they've selected the first item, if it's 1 they selected the second item etc.
If posting code please use code tags, see here.
Norie and Bellygas,
Many thanks for your help. Finding Me.LBYear.ListIndex=-1 did the job perfectly. I am still in trouble though.
The code I have written just runs past the MsgBox without giving the chance of selecting a year from the ListBox
So I end with an error in Sub ChooseMonth which needs a proper value in LBYear.
How do I get round this?
Hoping for more helpPlease Login or Register to view this content.
John
John
What do you want to happen if a year hasn't been selected?
If you want to return the user to the userform add an Exit Sub.
Please Login or Register to view this content.
Thank you very much for your help. Those two items are going to be very useful in the future as well.
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks