Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pop-up Calendar (2k)

    Hi all. I'm sure I've seen this somewhere in this forum, but can't find it anymore. What I'm looking to do is force the Calendar control to pop up when a cell is selected (using Worksheet_Change(ByVal Target As Range) ) and then enter the selected date into this cell.

    Any and all help much appreciated.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pop-up Calendar (2k)

    Lyra,

    See <post#=491,403>post 491,403</post: >. The attachment to that post is what you're looking for, I think.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up Calendar (2k)

    Spot on Hans! Thank you, that was the one I'd seen before but was using the wrong search terms.

    Thanks again. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •