highlight row / spin button

G

Guest

is it possible to highlight the first row in each listbox when the form opens
and then move the highlighted row either up or down with the spin button?

Thanks again for all of the help
 
G

Guest

Private Sub Userform1.Initialize()
for each ctrl in me.controls
if typeof ctrl is MSForms.Listbox then
ctrl.ListIndex = 0
end if
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spin button 4
Excel Forms Spin Button - Return to 1 after max value 0
spin up / spin down 2
Set focus to textbox after spin-button control is pressed?? 3
Spin Button Programming 1
Spin Box 2
automatically highlight a row when a cell in that row is selected 4
Spin Button's What can they do? 1

Top