| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for condition before running macro
I have 10 named non consecutive ranges Scl1 - Scl10. I am going to create a
Command bar to run a macro based on the current ActiveCell (Selection = Some value - from a user form). I need to understand how to test that the selected cell is indeed named Scl* or Scl# (a wildcard will work I think). If ActiveCell.range = "scl*" then UserForm.Show I also need a method for the UserForm to paste tthe data in the selected cell. Private Sub OptionButton1_Click() 'Private Sub Range(ActiveCell) = OurMagic I've tried everyway I can for the test function and have even less hair than when I started. TIA Lou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looping and stopping when a condition is met - test | Excel Discussion (Misc queries) | |||
| How do I test a condition in one cell and write to another. | Excel Worksheet Functions | |||
| logical test for an #N/A condition in a cell | Excel Discussion (Misc queries) | |||
| Test condition never satisfied in loop | Excel Programming | |||
| How to end when test condition met? | Excel Programming | |||
Threaded Mode
