Posted to microsoft.public.excel.programming

Taras

external usenet poster

Posts: 14

SetFocus using variable name

I would like to setfocus on a control in a user form
using a variable name.

ex:
sField = worksheets(5).cells(nval,1)
sField.SetFocus

The value in worksheets(5).cells(nval,1) would be the
name of a control on a user form

Can this be done?

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
SetFocus on a different sheet in VBA	AaronC	Excel Discussion (Misc queries)	1	June 9th 05 11:18 PM
SetFocus Problems	Zane Greer	Excel Programming	1	September 20th 03 02:26 PM
SetFocus problem	RFraley	Excel Programming	2	September 7th 03 01:18 PM
SetFocus method in VBA	Robin S.	Excel Programming	2	July 16th 03 10:20 PM
TextBox.SetFocus	steve	Excel Programming	4	July 16th 03 07:40 PM

All times are GMT +1. The time now is 01:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us