+ Reply to Thread
Results 1 to 3 of 3

Read Worksheet Data into Userform

  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Brighton,England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Read Worksheet Data into Userform

    Hi, I am new to userforms and badly need some help

    I have setup a userform to record fuel issued to vehicles.

    I have a text box which I would like to use to display the last meter reading from my fuel pump.

    This data is stored in the last cell in column F of "Sheet1" workbook.

    Is it possible to read this data into my userform so when it starts it displays
    the last pump reading?
    Last edited by msommerf; 09-10-2009 at 10:15 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Read Worksheet Data into Userform

    Hello Msommerf.

    This inserts the value of the last used cell in column F into textbox1, When the userform is initialized
    Please Login or Register  to view this content.
    Hope this helps.

  3. #3
    Registered User
    Join Date
    09-10-2009
    Location
    Brighton,England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Re: Read Worksheet Data into Userform

    D_Rennie,

    Thanks for the quick response. Worked a treat.
    Many Thanks
    Mark.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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