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: 989
Default Date / Time Picker V6.0 - Control moves location on userform!

I have 2 date/time pickers that are on the 3 page of a multipage on a userform.

For some reason, when you switch between pages, the 1st picker moves from
it's locations (left 198, top 66) to the far upper left corner of the form.
I have tried adding code to move it back whenever the multipage changes,
however, it doesn't work (despite the fact that the event triggers other
aspects of the code). Any ideas as to why its moving on me?

Private Sub MultiPage1_Change()

' Page 3: Set the date picker default value to the first of the current year

If MultiPage1.Value = 2 Then
With UserForm1
.DTPicker1.Value = DateSerial(Year(Date), 1, 1)
.DTPicker1.Left = 198
.DTPicker1.Top = 66
.DTPicker2.Value = DateSerial(Year(Date), Month(Date), Day(Date))
MsgBox .DTPicker1.Left
End With
End If

End Sub
 
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
Microsoft date and time picker control rapleyj Excel Discussion (Misc queries) 0 April 30th 10 05:37 AM
date and time picker control Ashku Excel Discussion (Misc queries) 0 July 22nd 06 11:18 AM
Problem With Date and Time Picker Control 6.0 Sunnous Setting up and Configuration of Excel 1 May 29th 05 11:35 AM
Problem With Date and Time Picker Control 6.0 Sunnous Excel Programming 2 May 27th 05 01:03 PM
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:31 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"