+ Reply to Thread
Results 1 to 6 of 6

Unhide row when input data from userform

  1. #1
    Registered User
    Join Date
    03-19-2016
    Location
    Latvia
    MS-Off Ver
    10
    Posts
    4

    Unhide row when input data from userform

    Hello there. Looking for code that will unhide row if i input data from userform. userform inputs data in (a)general and (b)date. c and d = formula. yeah, and how to autocopy this formula to next cells?
    Attached Files Attached Files
    Last edited by pulss; 03-22-2016 at 10:33 AM.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Unhide row when input data from userform

    Please Login or Register  to view this content.
    Kind regards
    Leo

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Unhide row when input data from userform

    Sorry I forgot the formula, to let this work remove the code from textbox
    Input in texbox for date can be

    d-m-yy dd-mm-yyyy d/m/yy dd/mm/yyyy

    output in sheet is dd/mmm/yy

    Please Login or Register  to view this content.
    Kind regards
    Leos

  4. #4
    Registered User
    Join Date
    03-19-2016
    Location
    Latvia
    MS-Off Ver
    10
    Posts
    4

    Re: Unhide row when input data from userform

    Niice that was fast. unhide works

    there is one more formula cells(nr, 4). and is there possible add code for conditional formating to entire row if it expired or expired soon?

  5. #5
    Registered User
    Join Date
    03-19-2016
    Location
    Latvia
    MS-Off Ver
    10
    Posts
    4

    Re: Unhide row when input data from userform

    something wrong in formula?

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-19-2016
    Location
    Latvia
    MS-Off Ver
    10
    Posts
    4

    Re: Unhide row when input data from userform

    nevermind i fount it out
    Please Login or Register  to view this content.

+ 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. userform to input data
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-14-2014, 02:58 PM
  2. VBA calculations are one step behind in the updating of sheet
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2014, 08:36 PM
  3. [SOLVED] Userform to input data in a hidden worksheet
    By jmsb in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-14-2013, 08:09 PM
  4. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  5. [SOLVED] Userform only to input data to Sheet only if textbox contains data/number.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2012, 11:30 AM
  6. Using userform to input data
    By SoCalRizzy in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-01-2008, 09:58 PM
  7. Input data to different sheets with a UserForm
    By asyamonique in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2008, 01:42 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