| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit entry in range
Hello group,
Please help, I am using Excel 97 with Win 95. I have a button with VBA code, I need an other code to limit the user to use this button in some range only (B10:B50). The button with not work outside this limit. Thank you very much for your time. Long |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit entry in range
at the beginning of your code for the button, check
Let us assume the button is designed to act on the activeCell At the top of the sub fired when the button is clicked: if intersect(activeCell,Range("B10:B50")) is nothing then exit sub -- Regards, Tom Ogilvy smi wrote in message ... Hello group, Please help, I am using Excel 97 with Win 95. I have a button with VBA code, I need an other code to limit the user to use this button in some range only (B10:B50). The button with not work outside this limit. Thank you very much for your time. Long |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit entry in range
Thank you very much Tom, your assume is correct. It work as I would like to.
Long "Tom Ogilvy" wrote in message ... at the beginning of your code for the button, check Let us assume the button is designed to act on the activeCell At the top of the sub fired when the button is clicked: if intersect(activeCell,Range("B10:B50")) is nothing then exit sub -- Regards, Tom Ogilvy smi wrote in message ... Hello group, Please help, I am using Excel 97 with Win 95. I have a button with VBA code, I need an other code to limit the user to use this button in some range only (B10:B50). The button with not work outside this limit. Thank you very much for your time. Long |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit data entry in range of cells | Excel Worksheet Functions | |||
| How do I limit entry into only 1 box of 10 choices available | Excel Discussion (Misc queries) | |||
| How can you limit the data entry range in Excel? | Excel Worksheet Functions | |||
| How do i put a limit on an entry in a cell? | Excel Discussion (Misc queries) | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Linear Mode
