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: 16
Default Repost: Calendar Control: Ron De Bruin

Hi Ron, the code below you posted earlier works great for
a whole column. How do I isolate it to one cell only,
say "d4", as I want the user only use the calender on one
cell.

Thanks,

Michael


Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Column = 4 Then
Calendar1.Left = Target.Left + Target.Width -
Calendar1.Width
Calendar1.Top = Target.Top + Target.Height
Calendar1.Visible = True
Else: Calendar1.Visible = False
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
Calendar control Marcus Excel Discussion (Misc queries) 1 December 5th 07 07:53 AM
Calendar Control -- Is this possible? Steve Excel Discussion (Misc queries) 2 December 29th 06 10:58 PM
Calendar Control Roleeb Excel Worksheet Functions 7 March 19th 06 09:15 AM
calendar control 10.0 timmulla Excel Discussion (Misc queries) 1 December 1st 05 12:38 AM
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin) Michael[_11_] Excel Programming 2 August 8th 03 01:16 PM


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

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

About Us

"It's about Microsoft Excel"