ListBox on UserForm SetFocus>resolved

James · May 21st, 2002, 11:12 AM

Hi,

When a UserForm is Activated i would like to have the ListBox "Have Focus"?

Thanks for any help.

Regards,
James

_________________

[ This Message was edited by: James on 2002-05-21 16:29 ]

Von Pookie · May 21st, 2002, 11:19 AM

Would ListBox1.SetFocus work for you?

James · May 21st, 2002, 11:26 AM

Hi Von Pookie,

No, i've tried that, any other ideas?

Regards,
James

James · May 21st, 2002, 11:26 AM

Hi Von Pookie,

No, i've tried that, any other ideas?

Regards,
James

Von Pookie · May 21st, 2002, 11:35 AM

As I've never used a listbox (as of yet), that was a guess on my part.

I've found the Userform Training workbook a rather helpful example by examining the code.

James · May 21st, 2002, 05:43 PM

Hi group,

What i meant when i posted listBox "taking focus" was when the Uf was activated the first row at the top of the ListBox was shaded blue, "had focus" without clicking on it. So.... it's all keyboard control > arrow up > arrow down and keypress enter.

Example:

UserForm1.Show.ListBox1.Selected(0)=True
UserForm1.Show

Regards,
James

May 21st, 2002, 11:19 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Would ListBox1.SetFocus work for you? __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

May 21st, 2002, 11:35 AM	#5
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	As I've never used a listbox (as of yet), that was a guess on my part. I've found the Userform Training workbook a rather helpful example by examining the code. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 11:12 AM	#1
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi, When a UserForm is Activated i would like to have the ListBox "Have Focus"? Thanks for any help. Regards, James _________________ [ This Message was edited by: James on 2002-05-21 16:29 ]

May 21st, 2002, 11:26 AM	#3
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Von Pookie, No, i've tried that, any other ideas? Regards, James

May 21st, 2002, 05:43 PM	#6
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi group, What i meant when i posted listBox "taking focus" was when the Uf was activated the first row at the top of the ListBox was shaded blue, "had focus" without clicking on it. So.... it's all keyboard control > arrow up > arrow down and keypress enter. Example: UserForm1.Show.ListBox1.Selected(0)=True UserForm1.Show Regards, James