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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet Component not setting focus 2
UserForm mechanics 6
Remove Focus from Form 1
Application.Visible = True and focus 3
Take Focus off a Modeless Userform and onto Worksheet? 4
Hidden sheet bleeds through 3
Changing focus question 1
Cursor placement within a form 1

Back
Top