Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spin Button [email protected] Excel Programming 4 June 12th 05 07:43 PM
spin button value tina Excel Discussion (Misc queries) 2 March 17th 05 02:11 PM
spin button bruce forster Excel Programming 1 May 7th 04 12:21 AM
Spin Button... scottnshelly[_25_] Excel Programming 4 April 30th 04 07:49 AM
Spin Button Andrew[_14_] Excel Programming 1 July 18th 03 01:51 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"