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