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



"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,

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,