Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click away from a form?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click away from a form?
You can only do this if you have Excel 2000 or later
Userform1.Show vbModeless -- Regards, Tom Ogilvy SCOTT wrote in message om... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I click on my cell, it directs to me an email form..........w | Excel Discussion (Misc queries) | |||
Right Click within Form | Excel Discussion (Misc queries) | |||
Why when I click on a pivot, form Getpivotdata isn't automatic | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) |