+ Reply to Thread
Results 1 to 5 of 5

Could somebody help me with the code of my VBA userforms(Combibox - saving - editing of da

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Could somebody help me with the code of my VBA userforms(Combibox - saving - editing of da

    Hello my name is sebastiaan and i am doing an internship in an company fort hat company i am trying to make an excel file that works with userforms to keep track of the maintance of the UV machines that are installed in section 1-8 and in 9-12 and in 13-16.

    Each section has 4 userforms:
    Main userform: Program1_8 & Program9_12 & Program13_16
    Nieuw(new) userform: Program1_81 & Program9_121 & Program13_161
    Login userform: Program1_82 & Program9_122 & Program13_162
    Bewerken(edit) userform: Program1_83 & Program9_123 & Program13_163

    The sheets are are as following:
    Main sheet: has the 3 tables that are connected tot the first Userform of each section and also connected tot the bewerken(edit) userform

    Lampnumber sheets: in these sheets i was planning to save the new entries of data from the nieuw(new) userform wich would be stored in its corresponding Lampnumber sheet in the table wich are marked by colour that belongs to one of the sections


    The working of the userforms should work as the following:
    The main userform is connected with the corresponding table in the main sheet and you can only look through the data with the main userform and not edit any data.
    The nieuw(new) userform would create an new entry of data that would be saved following the chosen Lampnumber in the corresponding table in the Lampnumber sheets in the rigth table colour that belongs to that section.
    The login userform works by using the login information and once typed right it should open the bewerken(edit) userform.
    The bewerken(edit) userform works by being connected to the table in the Main sheet that belongs to the corresponding section in the userform you can select the lampnumber and see all the information as you can aslo see in the Main userform only now you can edit it and save it.
    Login information:
    Name: Admin
    Ww: 1234

    The colours of the tables corresponding tot he sections are
    1-8: Blue
    9-12: Orange
    13-16: Green



    The problem that I have and I need help with is that don’t know or understand wich code I should use or need to use to make the Nieuw(new) userform work per section.
    or how to make the bewerken(edit) userform work so that it saves the data on the correct table in the Lampnumber sheets.

    I once asked on an other forum how to connect the combibox of Program1_8 with the table on the top of the Main sheet after wich i got an responce and an code to use i tried to edit the code so that it also works with the other userforms: Program9_12 and Program13_16 i hope that somebody could also provide me with the code for that or can explain it to me how to edit it correctly

    ^^^those are the probelms that i have and i hope that someone could help me with it.
    My main language is not english so i hope it is readble if there are any questions about anything that is unclear feel free to ask i will responce as fast as i can.

    I am looking forward to your responds thx already in forward.

    Greetings,

    Sebastiaan

  2. #2
    Registered User
    Join Date
    09-12-2018
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Re: Could somebody help me with the code of my VBA userforms(Combibox - saving - editing o

    i tried attaching the file to the post but after uploading the file to the site i could not attacht it so how can i fix that?
    Attached Files Attached Files
    Last edited by 19339; 09-12-2018 at 07:31 AM.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Could somebody help me with the code of my VBA userforms(Combibox - saving - editing o

    Hi
    go to edit > advanced > manage attachments

    then select workbook to upload

  4. #4
    Registered User
    Join Date
    09-12-2018
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Re: Could somebody help me with the code of my VBA userforms(Combibox - saving - editing o

    thank you i thought i had to choose the file with the paperclip icon after uploading it in the workbook

  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Could somebody help me with the code of my VBA userforms(Combibox - saving - editing o

    Your post does not comply with Rule 3 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums. That's all of them - I know of at least four others.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    Please make sure to include the full link, so that other members will be permitted to continue helping you

    Note that if you have fewer than 10 posts, you may need to type the link, or past it in pieces (or ask a mod to do that for you)
    Please familiarise yourself with the rules before posting. You can find them here.

+ 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. Auto fill text box after selecting a value in a CombiBox
    By OillyBob55 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-28-2017, 04:58 PM
  2. UserForms - Editing and Search Existing Data
    By freyasan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 03:38 PM
  3. Saving a workbook with userforms
    By ScotyB in forum Excel General
    Replies: 2
    Last Post: 02-13-2014, 04:56 PM
  4. UserForms and saving
    By j_Southern in forum Excel General
    Replies: 3
    Last Post: 12-07-2010, 08:17 AM
  5. buttons & userforms - saving data?
    By scotia81 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-26-2010, 01:32 PM
  6. Reloading and editing data in userforms
    By lcoreilly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2010, 10:43 AM
  7. Editing data with userforms
    By EDUcoordGR in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2009, 10:43 PM

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