+ Reply to Thread
Results 1 to 8 of 8

Popup userform when click cell

  1. 11-04-2015, 01:07 AM #1
    amein
    amein is offline
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Popup userform when click cell

    Q1. Solve
    Hey guys its me again, follow up from previous thread below

    http://www.excelforum.com/excel-gene...alue-30-a.html

    I add some micro to make date easier to insert date. but 1 problem arise when im using date picker, the next cell not calculate. but if manually insert date, calculation success. screenshot below. help me fix this..

    zR39Hef.png

    Q2.
    and BTW, is there anyway when i click cell to insert date then CALENDAR directly run/popup on the active cell instead what im doing now, i make 1 button on top right to insert date on active cell.

    excel attached.
    Attached Files Attached Files
    Last edited by amein; 11-04-2015 at 03:06 AM. Reason: 1 problem solved
    Reply With QuoteRegister To Reply
  2. 11-04-2015, 01:13 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Please help regarding FORMAT problem

    I tested it and it's working fine for me


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 11-04-2015, 02:20 AM #3
    amein
    amein is offline
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: Please help regarding FORMAT problem

    Quote Originally Posted by :) Sixthsense :) View Post
    I tested it and it's working fine for me
    really? thats weird... After i select "fill formatting only" then let say i select C27 cell and insert date using date picker but D27 cell not showing any result.hmmm...

    im using excel 2010 btw.
    Reply With QuoteRegister To Reply
  4. 11-04-2015, 02:38 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Please help regarding FORMAT problem

    Yes, it's working fine for me. I am also using the same environment (xl10)
    Reply With QuoteRegister To Reply
  5. 11-04-2015, 03:08 AM #5
    amein
    amein is offline
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: Please help regarding FORMAT problem

    Quote Originally Posted by :) Sixthsense :) View Post
    Yes, it's working fine for me. I am also using the same environment (xl10)
    Thanks, manage to solved it. any suggestion for Question number 2?
    Reply With QuoteRegister To Reply
  6. 11-04-2015, 03:21 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Popup userform when click cell

    Copy the below code and do right click on sheet tab and select view code and paste it.

    Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 11-04-2015, 03:33 AM #7
    amein
    amein is offline
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: Popup userform when click cell

    Quote Originally Posted by :) Sixthsense :) View Post
    Copy the below code and do right click on sheet tab and select view code and paste it.

    Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

    Please Login or Register  to view this content.
    haha.. thank you, its work! but not that i mean.. im sorry for my bad english.

    what i want is. when i click in any cell from row C(processing date) then date picker calendar will automatically open. instead what i have done so far by clicking then "insert date" button.

    jvamyWe.png <--------------- I want this popup when click active cell.

    sorry again for my confusing sentence..
    Reply With QuoteRegister To Reply
  8. 11-04-2015, 03:45 AM #8
    amein
    amein is offline
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: Popup userform when click cell

    SOLVED GUYS!! thanks!

    what i did is, just use this code

    Please Login or Register  to view this content.
    FINAL EXCEL FILE ATTACHED FOR FUTURE REFERENCE TO THOSE WHO NEEDED.

    Add: double click to enter date.
    Attached Files Attached Files
    Last edited by amein; 11-04-2015 at 04:18 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Format problem
    By rs1aj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2014, 04:58 PM
  2. Format Problem
    By aschwalge in forum Excel General
    Replies: 5
    Last Post: 01-24-2014, 05:50 PM
  3. format Problem
    By mohan.r1980 in forum Excel General
    Replies: 1
    Last Post: 11-17-2010, 08:35 AM
  4. XX,XX format problem
    By bhavin12300 in forum Excel General
    Replies: 7
    Last Post: 12-17-2009, 10:25 PM
  5. Format problem
    By wwoody in forum Excel General
    Replies: 3
    Last Post: 03-12-2008, 04:56 PM
  6. Format-Having a problem with a format column.
    By Bob W in forum Excel General
    Replies: 2
    Last Post: 01-23-2008, 05:54 PM
  7. Format Problem
    By cj21 in forum Excel General
    Replies: 7
    Last Post: 03-29-2006, 12:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1