LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default capture only part of inputBox or of cell contents

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking Up Part Cell Contents Steve Excel Discussion (Misc queries) 2 April 22nd 09 05:20 PM
#N/A if cell contents not part of an array MichaelR Excel Discussion (Misc queries) 5 June 28th 08 03:09 AM
InputBox to capture user selected sheet names? quartz[_2_] Excel Programming 7 December 3rd 05 10:51 AM
Can I use cell contents as part of a formula? Brian Rhodes Excel Worksheet Functions 3 June 3rd 05 05:00 PM
Capture changing cell contents from DDE links OttoMagic Excel Programming 0 August 6th 04 04:19 AM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"