Results 1 to 6 of 6

code for updating rows based on a userform combobox selection

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2013
    Location
    romania
    MS-Off Ver
    Excel 2007
    Posts
    3

    code for updating rows based on a userform combobox selection

    Hi,
    First of all I appologise if I didn't post this problem correctly, but I'm new to this forum, as well as to excel programming...
    I've created two Excel VBA forms: the first one pops up when the Workbook Opens and gives the possibility to:
    (1) enter a new project, and in this case Page1 from a Multipage of the second form is shown
    and
    (2) update an existing project, wich shows Page2 from the Multipage of the second form.
    Page2 of the second form contains a ComboBox that is populated with the projects allready entered. When a project is selected, data is retreived into the comboboxes and textboxes of the second form (on both pages), permitting the user to update fields.
    My problem resides in the fact that I can't get the form to update an existing record based on the Combobox selection. It only inserts new records, no matter what I do...I've tried various solutions found on the internet, but this being my first vba project, I'm a little overwhelmed by the situation...

    I've attached my workbook, where I've changed the captions of the various objects of the forms.

    Thank you in advance for your time and help!
    Attached Files Attached Files
    Last edited by raluk_ro22; 08-27-2013 at 07:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change Userform Label based on ComboBox Selection
    By rbyrd023 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-02-2014, 09:25 AM
  2. [SOLVED] Pre populating a userform from excel based on combobox selection
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2013, 12:09 PM
  3. [SOLVED] Change Labels in Userform based on selection in ComboBox
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-03-2013, 10:52 PM
  4. [SOLVED] How VB code can unhide/hide rows based on combobox selection?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2012, 01:25 PM
  5. Populating a userform based on a combobox selection
    By blindzero678 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2010, 03:37 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