Click away from a form?

  • Thread starter Thread starter SCOTT
  • Start date Start date
S

SCOTT

I need some help with a simple Excel VBA project. I have a form that
I want to have floating on top of the active worksheet as the user
moves from cell to cell. The form provides some shortcuts etc. that
the user may need. Problem is that when the workbook opens the form
is displaye (in the workbook i have userfrom.show) and I can not click
into a cell without hitting the x and macking it disappear. What am i
doing wrong?
 
You can only do this if you have Excel 2000 or later

Userform1.Show vbModeless
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cell values to an array, then array transpose to another workbook 8
Need Macro... 8
idiosyncracies of user form 4
Get data from sheet to form and back to a different sheet 1
Macro that will insert a simple text string in top cell of text file 1
User Form Problem 2
Excel Highlighting duplicates 0

Back
Top