Userform doesn't react on enter

  • Thread starter Thread starter Paulus
  • Start date Start date
P

Paulus

Hello helping friends
I've written an application in excel which shows an userform on
startup. The problem with this form is that it doesn't react on the
enter button. It should run through a couple of textboxes. Only if I
click a specialy made 'refresh' button, which hides the form and showes
it again in one Sub, solves the problem.

My problem is that asking the users to first click the button before
using is not very profesional.
Thanks in advance
Paul
 
If you have your Workbook_Open code in ThisWorkbook instead of the standard
code module it should open the form. Then you would need code attached to a
control on the form, or the form itself, to initiate the macro to run through
the text boxes. Hope this helps.
 
Thanks JLGWhiz. The form does open on workbook_open but then doesn't
respons on tab or enter to run through a couple of textboxes. Clicking
on the buttons however works fine. Strange isn't it? Only if I activate
userform.hide and userform.show it the tab or enter works again.
Paul
 
OK, it seems that you are looking for a change event rather than a click
event. Since I don't know what your current code is, I can't offer much more.
 

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

How do I enter a spreadsheet formula into a userform? 2
OK Button in UserForm 3
Userform textbox string to header causes unwanted double spacing 4
Userform is blank 4
Question about modal userform..... 2
Hiding a "Userform" instead of closing it??? 3
Userform question 1
Save data entered into UserForm to be Edited later 8

Back
Top