Forms and worksheet focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm fairly new to VBA programming (about 18hours to be exact), so be nice=)

I want to create a UserForm that has a few controls that will enter data
into a cell when it's selected and the form button clicked. However, when
the form is running, I'm unable to actually select a cell or gain focus on
the worksheet. Is there a way to overcome this?

thanks in advance,
 
in Form Property change the 'ShowModal' True to False

You can use RefEdit control for more use

pls do rate
 
Back
Top