+ Reply to Thread
Results 1 to 6 of 6

Help with code for userform text boxes, combo boxes and excel

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel
    Posts
    17

    Help with code for userform text boxes, combo boxes and excel

    Hi

    Im looking to create the code for the attached example. I have created the userform but ive only a little idea about how to use it within the example, so i have left out what code i have managed to find, via the forum, as it has confused me a little.

    What i would like to do is, upon opening the workbook the userform appears, the info is filled in on the left hand boxes and choices picked from the combo boxes and the info is entered onto the worksheet on the next available row. Once the info is either approved or rejected the userform is opened again, the number entered along with the date and the check box is ticked to confirm either approval or rejection. Once done the userform can be closed.

    Thanks in advance.

    Schedule.xls

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Help with code for userform text boxes, combo boxes and excel

    Hi,

    The comboboxes are filled by the lists on the "Notes" sheet, the adding of records works already as long as the date field filled on the form. There are only numberics allowed for Date and number fields.

    One open question: when you have records in your sheet already and want to set the status (approval/rejection+date and number) you certainly want to do this for only 1 record, how do you want to select the record? Enter the name ect. on the left manually? not user-friendly. I'd make 2 forms, 1 for adding new records and another for setting the status. Example here:
    Schedule.xls

    Would also be helpful to have some sample data.

    Regards
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel
    Posts
    17

    Re: Help with code for userform text boxes, combo boxes and excel

    Hi, thanks for your reply. I will be able to give more feeback next time i am working on a machine with excel and also try out your example. I will also provide more details.

    Cheers

  4. #4
    Registered User
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel
    Posts
    17

    Re: Help with code for userform text boxes, combo boxes and excel

    Hi

    I have put a couple of completed lines of data in (didnt think it was worth putting more in as each line will be much the same). See attached...

    The userform on this example, is that the 2 forms you suggested?

    The number should be used when approving/rejecting the request, can the number be entered on the right hand form, be used to locate an existing entry (there maybe more than one entry using the same number, so should i add another field that would determine the entry number?), add in the date of receipt, then choice whether the request has been approved or rejected...

    I hope i am explaining myself, as i seem to be getting in a tangle!

    Thanks for all the help in advance.

    Cheers

    Schedule.xls

  5. #5
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Help with code for userform text boxes, combo boxes and excel


  6. #6
    Registered User
    Join Date
    12-06-2012
    Location
    Tampa Florida
    MS-Off Ver
    Excel 2003 or 2010
    Posts
    5

    Re: Help with code for userform text boxes, combo boxes and excel

    Question about the solution:

    May I take this one step further. I have a similar userForm that uses combo boxes. I would like the data in one combo be dependent on the selection of the 1st selection.

    In the above sheet (schedule.xlsm) can the "type" combo be filtered based on the "name" selected. (i.e certain individuals are responsible for certain types)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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