+ Reply to Thread
Results 1 to 5 of 5

update data based on listbox & textbox

  1. #1
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    209

    update data based on listbox & textbox

    Hi guys,

    I am stressing out a tad as I cant seem to get this to work. I guess I dont understand coding enough...

    Currently I can;
    1. populate a Listbox
    2. based on the listbox details can transpose that data into various textboxes.

    What i cant do is workout if someone updates\changes the data within the text boxes how to update the data on a worksheet.

    I cant seem to work out how to find the row's address and then reference off of that to find the row of the selected list box entry and thus move along the row to update.


    I have attached my WB.. if one were to launch the user form > search for a user (i.e. Pintal), the users details will appear but then i need to create some code to update.

    I have failed to work this out in 5 hours so i dont think im going to work it out without your help unfortunatly,,,

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    209

    Re: update data based on listbox & textbox

    I was able to do a work around: instead of using the ROW number i used the SKU number (unique to each entry)

    Please Login or Register  to view this content.

    I would still very much like to know how to work this out via just the rows address.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: update data based on listbox & textbox

    You do realise that the size of your form is excessive & will not fit correctly on some screens?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: update data based on listbox & textbox

    Hi

    Please Login or Register  to view this content.
    defaults to the row number in the item selected. Isn't this what you are chasing?

    rylo

  5. #5
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    209

    Re: update data based on listbox & textbox

    Roy - no i did not know that - ive used it on 2 differnt computers and they all fit - maybe ill play around with the Res and see how it looks.


    rylo - thanks, ill give it ago as my code works fine now, though it would be cleaner to reference the row.

    will advise back,

    thanks,

+ 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