Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if textbox is open
There are textboxes in several sheets and they are used to inform the user
of the status of the work being undertaken on the sheet. On a typical sheet a command button is clicked by the user and a textbox will display a message, when another command button is clicked on the same sheet the first textbox message disappears and a new textbox message appears. One textbox sits on top of the other, so it gives the impression there is only one textbox. Several sheets operate in this way on the same workbook. My question is: if the user performs an action on a sheet that does not have a textbox he needs to be warned if a particular textbox is TRUE on one of the sheets where textboxes are being used. Here is I will demonstrate what happens on a typical sheet where textboxes are being used. Commandbutton1: TextBox7.Visible = False TextBox8.Visible = True Commandbutton2: TextBox8.Visible = True TextBox7.Visible = False Thank you if you can help with this problem. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then to check if a workbook is open | Excel Discussion (Misc queries) | |||
Check if form is open | Excel Programming | |||
Textbox error checK problems | Excel Programming | |||
spell check a textbox | Excel Programming | |||
check variable(text) with cell (text), textbox | Excel Programming |