| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If/Then help in returning value
I've treked through the Excel Tips and search time and again through th
history on here but can't find anything that answers my query.....an I'm pretty new to all this! Please can anyone help? I am basically trying to write a macro that says.... If Sheet2, CellA5 =1 then run box1.show If Sheet2, CellA5 =2 then run box2.show If Sheet3, CellA5 =3 then run box3.show Trouble is Sheet2 is very hidden and protected so I can't go to th cell and say 'If activecell' etc.....well I suppose I can but i involves unhiding it and it contains the guts of my application. I there any easy way? Any ideas please? Many thanks -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning a sum value | Excel Discussion (Misc queries) | |||
| Returning the value | Excel Discussion (Misc queries) | |||
| UDF from Add-In returning #NAME | Excel Worksheet Functions | |||
| UDF returning #VALUE! why? | Excel Discussion (Misc queries) | |||
| =if returning 0 | Excel Worksheet Functions | |||
![Big Chris[_34_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
