Posted to microsoft.public.excel.programming

anupam[_3_] anupam[_3_] is offline

external usenet poster

Posts: 1

Referring Date in VBA

If c.Value <= #7/8/2004# Then
c.Value = #7/1/2004#
End If

but in this code i want to refer month as variable. i will accept th
month from user using inputbox.

how can i use variable for month in this code.

??????

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Referring a cell	Terry0928 via OfficeKB.com	Excel Discussion (Misc queries)	3	May 21st 10 09:22 AM
putting date in a cell referring to the tab sheet	Rachel	Excel Discussion (Misc queries)	1	November 6th 09 06:16 PM
Totalling by referring to 2 date ranges	Mike	Excel Discussion (Misc queries)	2	March 30th 05 01:59 AM
Totalling by referring to 2 date ranges	Mike	Excel Discussion (Misc queries)	0	March 29th 05 11:57 PM
referring to other worksheet	Geetu M	Excel Worksheet Functions	2	March 29th 05 09:37 PM

All times are GMT +1. The time now is 12:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us