| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Cell equals "XXX" Then......
I am trying to create a macro that if Cell "B15" which is formated as
"mm/dd/yyyy" = "June/dd/yyyy" then Sheets("June").Select and so on for each month. I know a longer way of accomplishing this but was just wondering how to do it without all the code. Thank you to anyone who helps and all you wonderful people out there that make this discussion group so valuable by sharing all your knowledge! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Cell equals "XXX" Then......
if not isdate(activecell) then exit sub worksheets(format(Activecell.Value,"mmmm")).Select -- regards, Tom Ogilvy "Benz" wrote: I am trying to create a macro that if Cell "B15" which is formated as "mm/dd/yyyy" = "June/dd/yyyy" then Sheets("June").Select and so on for each month. I know a longer way of accomplishing this but was just wondering how to do it without all the code. Thank you to anyone who helps and all you wonderful people out there that make this discussion group so valuable by sharing all your knowledge! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Cell equals "XXX" Then......
It works wonderful, Thanks Again Tom!
"Tom Ogilvy" wrote: if not isdate(activecell) then exit sub worksheets(format(Activecell.Value,"mmmm")).Select -- regards, Tom Ogilvy "Benz" wrote: I am trying to create a macro that if Cell "B15" which is formated as "mm/dd/yyyy" = "June/dd/yyyy" then Sheets("June").Select and so on for each month. I know a longer way of accomplishing this but was just wondering how to do it without all the code. Thank you to anyone who helps and all you wonderful people out there that make this discussion group so valuable by sharing all your knowledge! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells only if cell X equals "yes" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| if cell equals "a" then another cell would calculate percentage | Excel Worksheet Functions | |||
| Sumif formula that uses "contains" rather than "equals" | Excel Discussion (Misc queries) | |||
| if cell contains string then make cell next to it equals "X" | Excel Programming | |||
Linear Mode
