clipro
Board Regular
- Joined
- Jan 12, 2005
- Messages
- 195
Hi All,
I have got two sheets in a workbook and I am trying to create a macro that must:
On Sheet1 there is a button "submit Changes" that starts the Macro
1.In Sheet1 to check the value of cell A1 (the value depends of formula result)
2. If the value of cell A1 is 1 to go to (select) the Sheet2
3. If the value of Cell A1 is 2 to show a message box (OKonly) that must to take the text from cell A2
par example the text in A2 is "You have missed the first name of the customer"
I have one code that is too far away of this one that I need. Can you help me?
I have got two sheets in a workbook and I am trying to create a macro that must:
On Sheet1 there is a button "submit Changes" that starts the Macro
1.In Sheet1 to check the value of cell A1 (the value depends of formula result)
2. If the value of cell A1 is 1 to go to (select) the Sheet2
3. If the value of Cell A1 is 2 to show a message box (OKonly) that must to take the text from cell A2
par example the text in A2 is "You have missed the first name of the customer"
I have one code that is too far away of this one that I need. Can you help me?