Posted to microsoft.public.excel.programming

external usenet poster

Posts: 557

PLEASEEEE HELP. DATE AND TIME PICKER CONTROL

Hi all, Can please any body can help that how can i write a macro to
a button which can SetFocus to Date and Time Picker Control on sheet.
Like i want macro to select inside the date field of Date and Time
Picker Control when i click the button. I tried (see below the code)
but not working. Please help

Private Sub CommandButton1_Click()
Me.DTPicker1.SetFocus
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Date & Time Picker Control 6.0	JAD	Excel Programming	2	September 10th 08 04:04 PM
date and time picker control	Ashku	Excel Discussion (Misc queries)	0	July 22nd 06 11:18 AM
date time picker control	MacroCharlie	Excel Programming	0	November 16th 05 04:01 PM
Problem With Date and Time Picker Control 6.0	Sunnous	Setting up and Configuration of Excel	1	May 29th 05 11:35 AM
Date and Time Picker Control	Andy T	Excel Discussion (Misc queries)	0	January 6th 05 04:09 PM

All times are GMT +1. The time now is 04:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us