M
Minitman
Greetings,
I have an entry sheet that calls up several UserForms to help enter in
data. In redesigning this sheet, I realized that I don't know how to
use an entry into a cell within a named range to trigger a UserForm to
become visible.
Right now, I have three Command Buttons (Button 1, Button 2 and Button
3). Button's 1 & 2 will make themselves not visible and make the
CommandButton called "SAVE" visible - these work fine.
It is Button 3 that needs the adjustment. At present, by pushing it,
I go directly to the next step in the entry process. This is a
mistake. I need to have the sheet check to see if any changes had
been made to the Named Range called "CustInfo". If there were any
changes, then make visible the CommandButton called "SAVE". If not,
then go on to the next step.
Could someone tell me what that event trigger is called and how to use
it? Any help would me most appreciated.
TIA
-Minitman
I have an entry sheet that calls up several UserForms to help enter in
data. In redesigning this sheet, I realized that I don't know how to
use an entry into a cell within a named range to trigger a UserForm to
become visible.
Right now, I have three Command Buttons (Button 1, Button 2 and Button
3). Button's 1 & 2 will make themselves not visible and make the
CommandButton called "SAVE" visible - these work fine.
It is Button 3 that needs the adjustment. At present, by pushing it,
I go directly to the next step in the entry process. This is a
mistake. I need to have the sheet check to see if any changes had
been made to the Named Range called "CustInfo". If there were any
changes, then make visible the CommandButton called "SAVE". If not,
then go on to the next step.
Could someone tell me what that event trigger is called and how to use
it? Any help would me most appreciated.
TIA
-Minitman