View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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