Posted to microsoft.public.excel.programming

MattShoreson[_117_] MattShoreson[_117_] is offline

external usenet poster

Posts: 1

Easy Declare Variable

if month(dtpicker.value)=8 then
variable1 = right(year(dtpicker.value),2) & "/" & _
right(year(dtpicker.value)+1,2) & " Grant Year"
else
variable1 = right(year(dtpicker.value)-1,2) & "/" & _
right(year(dtpicker.value),2) & " Grant Year"
endi

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=56325

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
Declare variable as what?	N E Body	Excel Programming	6	October 28th 04 01:06 AM
Declare Variable	zapatista66[_13_]	Excel Programming	0	October 7th 04 04:13 PM
Declare Variable	zapatista66[_11_]	Excel Programming	1	October 7th 04 03:23 PM
Declare Variable	zapatista66[_10_]	Excel Programming	0	October 6th 04 09:02 PM
Declare Variable	zapatista66[_9_]	Excel Programming	1	October 6th 04 08:47 PM

All times are GMT +1. The time now is 04:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us