Forms and worksheet focus
 

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,

Forms and worksheet focus
 

in Form Property change the 'ShowModal' True to False

You can use RefEdit control for more use

pls do rate



"robbie" wrote:

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,

Forms and worksheet focus
 

That did it. Thank you kindly.

Did I rate it?



"Muhammed Rafeek M" wrote:

in Form Property change the 'ShowModal' True to False

You can use RefEdit control for more use

pls do rate



"robbie" wrote:

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,