+ Reply to Thread
Results 1 to 6 of 6

Transfer data to and from userform

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    28

    Question Transfer data to and from userform

    Hi all, I was wondering if someone could offer coding advice to solve some problems for an excel novice.

    I have attached a mock up sheet for demonstration purposes. This spread sheet is to be designed to be as simplistic as possible; the entire interface will be form based with no direct access to any cell data. The attached mock up contains three forms; a front end prompt on load, one form for order entry and one form for editing an existing order. I had considered dropping the third user form entirely and just re-use the order entry form for both order entry and modifying an order as it would appear more efficient but for this mock up, its three forms.

    My problem is 3 fold. Whilst User form 2 writes to worksheet cells correctly and via user form 3, I can retrieve the relevant cell information, the problem is that any changes I make using user form 3 will create a new entry on the worksheet, when what I want is for it to just modify the relevant order information; also, how best could I implement an alpha numeric order number search lookup and lastly when an order is written to the sheet, how best to simultaneously apply formatting to the data?

    Your help is much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Transfer data to and from userform

    Fixed form 3, not sure what you mean by implementing alphanumeric lookup. Right now in OrderNum you search numbers only, but clearly that's on purpose because the code only tries to match if IsNumeric is true... clearly that was by design?
    The fix for form 3 i used was a private variable which is used to record the row offset from A1 where your Order Number match was located.
    Attached Files Attached Files
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    28

    Re: Transfer data to and from userform

    Hi Arkadi, the updating works now. Thank you.

    You are correct in that by design I added numerical order numbering for simplicity in this example but the reality is that the order numbers would be A12345, AA12345, ABC12345, no set pattern. Do you have any suggestions on how this would be best achieved?

    Again, many thanks

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Transfer data to and from userform

    What about simply taking out the if isnumeric condition on the textbox change event?

  5. #5
    Registered User
    Join Date
    03-05-2014
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    28

    Re: Transfer data to and from userform

    It was staring me in the face, thanks again for that too

  6. #6
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Transfer data to and from userform

    Yeah any time JumpyJim

+ 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. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  3. [SOLVED] Userform to transfer data to another userform
    By Oeysbrei in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2012, 04:46 PM
  4. Transfer Data in Userform
    By vin1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2012, 09:57 AM
  5. Transfer data between Userform.
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-30-2009, 11:49 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