+ Reply to Thread
Results 1 to 4 of 4

Please help - cell needs to show date selected on calendar

  1. #1
    Registered User
    Join Date
    10-26-2016
    Location
    Lichfield, England
    MS-Off Ver
    2013
    Posts
    14

    Please help - cell needs to show date selected on calendar

    Hi there,

    Wondered if anyone could help with this?

    If you see the attached sheet, you'll see a calendar on the right hand side, is it possible that, if you click on a date on the calendar (cells Q12, R12, S12 etc) that the date selected could show in Cell D8?

    Hope this makes sense.

    Thanks in advance.

    Matt
    Attached Files Attached Files

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Please help - cell needs to show date selected on calendar

    Put this in the worksheet module:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    10-26-2016
    Location
    Lichfield, England
    MS-Off Ver
    2013
    Posts
    14

    Re: Please help - cell needs to show date selected on calendar

    Thanks Olly! That's brilliant, really appreciate your help.

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Please help - cell needs to show date selected on calendar

    Happy to help, thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel VBA, Macro Shortcut: Create Outlook Calendar Based On the Date of the Selected Cell
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2016, 10:23 AM
  2. Populating Calendar with name from another sheet when a date is selected.
    By Discussions63 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2016, 09:27 PM
  3. How to close a calendar control when a date has been selected?
    By Gordon1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 05:56 AM
  4. Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  5. [SOLVED] Show today's date on calendar
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 04:23 PM
  6. Connecting date selected on a calendar to a specific cell
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2011, 05:09 PM
  7. Show Calendar When Cell is Selected
    By siamadu in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-26-2009, 02:12 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1