Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar control | Excel Discussion (Misc queries) | |||
Calendar Control -- Is this possible? | Excel Discussion (Misc queries) | |||
Calendar Control | Excel Worksheet Functions | |||
calendar control 10.0 | Excel Discussion (Misc queries) | |||
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin) | Excel Programming |