Hi everyone,
I'very, very new around.
I'me sure this topic has already been discussed, if so, can you redirect me?
very simple, but don't seem to find the answer:
I've got a listbox1 in worksheet1
I want it to show the firts item using VBA
(selected ? item ? Index ? )
can't make it work.
Thank you
Hi,
What kind of listbox is it- ActiveX or Form control?
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi, and welcome to the forum.
Please upload the workbook and explain which item you expect to see in the list box.
Then what do you expect? I sense that you want to move to that first item, but in which case what's the point of displaying it in a listbox? Why not save yourself a step and just have a macro attached to a button which when clicked takes you to the first item?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you for quick reply.
It's an ActiveX.
I've finaly found the answer.
If i put the index value to zero and then select the firts item, listbox will unselect all item, srcoll to top and show first item selected.
It wasn't so obvious at firts and i was struggling to get it right.
ActiveSheet.Shapes("Caixa de listagem 1").ControlFormat.ListIndex = 0
ActiveSheet.Shapes("Caixa de listagem 1").ControlFormat.ListIndex = 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks