highlight row / spin button
 

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
--
JT

highlight row / spin button
 

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

--
Regards,
Tom Ogilvy


"JT" wrote:

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
--
JT