Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Help. In inputBox the user enters a date (not usually the current date) for a
month for which he wants to enter data. This is stored in the variable "userMonth" and entered into Range("F1"). I then use contents of F1 in a Find method to select a cell (labled mmm) into which to paste the entered data. My code checks inputBox entry for a valid date. If entry is valid (say, mmm,yy), here's the rub: I need to use only the mmm part in the Find method. Is it possible to capture only the mmm part of the entry or alternatively to retrieve only the mmm part from F1? Format (Date,"mmm") doesn't work here because the date may not be the current date. I know that I could have the user enter only the mmm in the inputBox but then I can't check that the entry is a valid date (at least I don't think I can). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking Up Part Cell Contents | Excel Discussion (Misc queries) | |||
#N/A if cell contents not part of an array | Excel Discussion (Misc queries) | |||
InputBox to capture user selected sheet names? | Excel Programming | |||
Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
Capture changing cell contents from DDE links | Excel Programming |