| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Verify correct cell
I have a rectangle on Sheet1, when the user clicks this rectangle I want to
make sure they are in 1 of 7 cells that will receive the information they will enter from a userform. If they are in one of these 7 cells the userform will load but if they are not a message will show that they are in the wrong cell and cannot enter the information. Can this be done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Verify correct cell
Hi
Dim ChkRng Set ChkRng = Intersect(ActiveCell, Range("A1:A7")) If ChkRng Is Nothing Then MsgBox "Sorry, can't go further active cell is not in the required range" Exit Sub Else 'do your stuff End If HTH Cordially Pascal "jnf40" a écrit dans le message de news: ... I have a rectangle on Sheet1, when the user clicks this rectangle I want to make sure they are in 1 of 7 cells that will receive the information they will enter from a userform. If they are in one of these 7 cells the userform will load but if they are not a message will show that they are in the wrong cell and cannot enter the information. Can this be done? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Verify correct cell
Thanks worked great.
"papou" wrote: Hi Dim ChkRng Set ChkRng = Intersect(ActiveCell, Range("A1:A7")) If ChkRng Is Nothing Then MsgBox "Sorry, can't go further active cell is not in the required range" Exit Sub Else 'do your stuff End If HTH Cordially Pascal "jnf40" a écrit dans le message de news: ... I have a rectangle on Sheet1, when the user clicks this rectangle I want to make sure they are in 1 of 7 cells that will receive the information they will enter from a userform. If they are in one of these 7 cells the userform will load but if they are not a message will show that they are in the wrong cell and cannot enter the information. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to verify addresses and zip codes are correct? In bulk... | Excel Programming | |||
| Verify Active Cell is within a Range that changes as cell is delet | Excel Programming | |||
| Verify Active Cell | Excel Programming | |||
| Verify if Comment exist in a cell | Excel Discussion (Misc queries) | |||
| verify cell if is the same | Excel Programming | |||
Linear Mode
