+ Reply to Thread
Results 1 to 3 of 3

Populating My Userform Boxes with the Data I'm Editing

  1. #1
    Registered User
    Join Date
    07-08-2015
    Location
    Richmond, Virginia
    MS-Off Ver
    Office 13
    Posts
    37

    Populating My Userform Boxes with the Data I'm Editing

    Right now I have a form where the user chooses an event from a combo box, types the start day (mm/dd/yyyy) and end day (mm/dd/yyyy) and types comments in a text box. I made it so the user could double click on previously created events and edit them, but the form shows up blank. How can I have the form open with the data that is to be edited showing up in each of the boxes?

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: Populating My Userform Boxes with the Data I'm Editing

    It seems to me you only need to edit the cells on the sheet to make changes.
    but to use a form,
    (open form)
    cboBox = activesheet.Range("A2").value
    txtBox = activesheet.Range("A10").value

  3. #3
    Registered User
    Join Date
    07-08-2015
    Location
    Richmond, Virginia
    MS-Off Ver
    Office 13
    Posts
    37

    Re: Populating My Userform Boxes with the Data I'm Editing

    The problem is that the range is always changing. If someone enters 09/01/2015 as the start and 09/10/2015 as the end, (the way my sheet is set up) the range (activeCell.Row, column AG) - (activeCell.Row, column AP) gets highlighted. If someone enters a different date range, it could be on a different row and different columns. I don't actually save the dates in a specific cell.

+ 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. Editing Userform Data
    By cmoore24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-20-2015, 09:42 AM
  2. Populating userform word boxes based on listbox selection
    By trcrossland in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-12-2014, 12:55 PM
  3. populating list boxes and combo boxes in a user form.
    By ahceinaej in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:54 AM
  4. [SOLVED] Populating a userform from a search button and editing the workbook
    By jonesdwj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-16-2013, 01:55 AM
  5. Problem with populating text boxes with filtered data
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2013, 04:27 AM
  6. Editing Data Through A Userform
    By WoodsyMP5K in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2012, 02:30 AM
  7. Auto populating UserForm Combo and Text boxes from Validated data sets
    By ZIXILPLIX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2010, 12:55 AM

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