Greetings,
I am using the following code to access an Userform listbox. I am needing to disable the first row from being accessed.
Please Login or Register to view this content.
Greetings,
I am using the following code to access an Userform listbox. I am needing to disable the first row from being accessed.
Please Login or Register to view this content.
First I notice that this code is for double-click. Normally you would use the click or change event to manage user selections on a listbox. How are you expecting users to use this listbox?
Second, what do you mean by "disable the first row from being accessed"? Do you want to make it impossible for the user to click on that row? Or just ignore it if they do?
Thank you for your response.
The users will ddb click on a row that opens a different Userform to allow for changes to be made.
I want to make it impossible for the user to click on the first row or just ignore. Not to b able to open and modify.
Add this line to your code. Nothing will happen if the user selects the first item.
Just curious--why are you putting an item in the list box that the user can't select?
Please Login or Register to view this content.
6StringJazzer,
Works perfectly!!!
The reason is the first row contains an "-" for listing value.
You're welcome and thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks