+ Reply to Thread
Results 1 to 3 of 3

Monthview date picked placed in each cell of table column, instead of in selected cell

  1. #1
    Forum Contributor
    Join Date
    05-02-2012
    Location
    Mosselbaai, Suid Afrika
    MS-Off Ver
    Excel 2016
    Posts
    107

    Monthview date picked placed in each cell of table column, instead of in selected cell

    Monthview date picked placed in each cell of table column, instead of only in the selected cell:

    I have a monthview userform that “pops up” when any cell in a given range in a table is double clicked. It is supposed to put the picked date in the selected cell, unfortunately I could not get that to work. At the moment it place the picked date in all cells of the given range!

    In the code in the form “frmPopUpCalendar” module:
    Please Login or Register  to view this content.
    I want to replace the line
    Please Login or Register  to view this content.
    which puts the selected date in all of the cells of the selected column
    with the following line,
    Please Login or Register  to view this content.
    so as to only put the date in the selected cell, but when I do that nothing gets written in the cell??!!

    The code of sheet “Intersect Table Column”:
    Please Login or Register  to view this content.
    In a normal module the following code:
    Please Login or Register  to view this content.
    Regards,
    Henk

  2. #2
    Forum Contributor
    Join Date
    05-02-2012
    Location
    Mosselbaai, Suid Afrika
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Monthview date picked placed in each cell of table column, instead of in selected cell

    File Attached.

    Regards,
    Henk
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-02-2012
    Location
    Mosselbaai, Suid Afrika
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Monthview date picked placed in each cell of table column, instead of in selected cell

    How do I fix the following line of code?

    Please Login or Register  to view this content.
    Regards,
    Henk

+ 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. Highlight first cell in a row and specific row in column if cell is selected
    By Abbadon486 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-29-2014, 08:54 AM
  2. Problem with using a date, picked from a cell, within my formula
    By HMDSP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2013, 06:58 AM
  3. Insert Date When Cell in specific column is selected
    By G33kman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 08:19 PM
  4. [SOLVED] Date problem in monthview userform
    By h0ps in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2012, 12:10 PM
  5. Merging MonthView & DTPicker Valuie into one cell
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-01-2009, 06:41 PM

Tags for this Thread

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