vba userform

  1. E

    Userform Combobox - Put data in cells according to selection

    I have an userform with two Comboboxes and a textbox. Combobox1 has a string of time slots. The selection of combobox1 should define in which row the data from textbox1 is put. Combobox2 is populated by the same text as columns B to I, the selection should define in which column the data from...
  2. B

    Select Sheet from External Workbook

    Hello. I have a userform where a user will select an external workbook that will then import the sheet to the current workbook. The issue that arises is when the external workbook has more than one sheet. So, my plan was to have another userform pop up when the external workbook's sheet count is...
  3. S

    UserForm Malfunctioning after 70 plus calls

    Good Afternoon all! I am a noob to vba and have been working on a project for work. It's basically an inspection form for our machined parts. We measure the part with the caliper, the measurement goes into the userfrom and then gets transferred to the next empty cell in the corresponding...
  4. P

    User Form Data Transfer Taking Several Minutes To Update Vs Seconds

    All, I am having trouble with taking information from a user form and populating that information into a database. Looking for as much feedback as I can get to speed up this process to several minutes 5+ - 10+ minutes depending on the day down to seconds if possible. The bottleneck, from...
  5. K

    Validate the value entered to a text box of a User Form using the data in another Work sheet

    I am very new to Excel VBA and any help from you is highly appreciated. I have two work sheets as Inhouse Material Inventory and Service Details. Inventory work sheet contains Materials available in our inhouse inventory and their available quantity. I am using a user form to feed data into the...
  6. A

    Userform throwing a 438 error on hiding workbook

    Hi all, Hope you can Help i'm fairly new to VBA and Userforms. We have a userform which we want filling in but don't want to show the excel in the background as we want to try limit anyone from going in and updating it, this works fine if there are no other workbooks open but if there is the...
  7. Q

    VBA Syntax Help

    Right now, I have a working VBA that allows me to input something into my first Text Box TB1 and it will change what is in cell A2 on the current worksheet. Then, based on what is inputted, the rest of my text boxes will then change what is in cells B2-Y2. The other text boxes in my VBA form...
  8. J

    Need help with Update, Next & Previous button for multi-page Userform

    Hello, First time poster and Self taught VBA Novice here in need of some assistance. I'm off to what I feel is a solid start with Excel 2013and my multi-page UserForm, however now I've lost all functionality with exception of initialization of the userform populating data from worksheet cells...
  9. A

    VBA Userform TextBox value dependant on ComboBox selection

    Dear All, I am trying to run a userform where a TextBox value is based on the selection of a ComboBox, i.e. the user would select a service and theform would bring up a predefined price from a table with vlookup. The codes currently look like this: Private Sub CboService_Change() With Me...
  10. E

    VBA for Previous and Forward button

    I am getting compile errors on the click command on the 'forward' and 'back buttons' on a form – can someone take a look? My work book is on my one drive https://1drv.ms/u/s!Ag-WnkpUjiS9hy6MzsFk56w7ZJ8o This is my form: Previous button code: <code style="box-sizing: border-box...
  11. G

    Loop and Check box

    Hello, I have designed a form with about 160 controls among about a third of checkboxes. The purpose for the users is to be able to check several checkboxes and when they validate the form vba will create a new entry in an excel sheet. I've written the following code but can't make it work...
  12. C

    My UserForm is really slow to post

    I'm making multiple userforms on one Workbook. each userform is used to enter data on a different sheet (different inputs and different columns for different sheets) It used to enter data almost instantaneously however now it's taking about 10 seconds after i press the enter button. I've...
  13. S

    userform calendar in excel 2013

    hello again, I have below questions with which I need help/suggestions please. 1. A userform created in excel 2007 which has calendar control option in additional controls - will this work as it is if system having 2013 on it? 2. How do I get Calendar control in 2013? If not, the code? 3. I...
  14. P

    showing windows username in a text box - access form

    Hi, I'm completely new to Microsoft Access. I've built a userform and I would like to display the windows ID/logon ID in a text box. Please could you guide me through the steps? very much appreciated Cheers, Anthony
  15. A

    Excel VBA UserForm, Checkbox's to print sheets & Save as new workbook

    I am in need of a bit of assistance, i am trying to create a UserFrom that creates checkbox's based on sheet names. It will then have 4 button, 1:Print, 2:Save New Workbook, 4:Clear Selection, 5:Cancel. This is the code i have that creates the checboes, and changes the captions to the sheet...
  16. J

    Validation Loop Controls - VBA Userform

    I'm writing a portion of data validation for my current userform and I'm struggling to get a loop function to work properly. Currently when running the userform if you miss out a data entry it pops up with a window telling you data is missing and then unloads the userform. I get that I need a...
  17. J

    Find next blank row in specific column

    I'm quite new to VBA and have been playing with this for days. It's a little hard to explain: There are 3 sets of option buttons on a userform, which column the data is entered into is dependant on the permutation of these results. However, I can't work out how to look for the next empty row...
  18. D

    input from vba user form

    hi i am new to vba i want to Update cells via a user form. user enter data in form and update in some cells like c5, c6, d5, d6, e6. e7. one more thing i want to show some data from the sheet on a user form. please help me... below given is code for 1st user form. Option ExplicitPrivate Sub...
  19. Z

    VBA, Userform, Send Email, Checkbox Select Sheets to Email as PDF

    I have this code, not sure how to post in the correct code format, but here is what i am looking to do. I am looking to take this code, make it so that I can have 4 checkboxes in my Userform. when any one of those 4 check boxes are selected it will attach a certain sheet (named the same as the...
  20. Alan_P

    VBA UserForm - "Pasting" array values on individual lines in a textbox

    Hello All, I have this code that searches for the selection in a ComboBox in a specific column then "copy & pastes" a cell on the same row into a TextBox (3 cells & 3 text boxes), I'm trying to get each found item on a new line in the text box. The code below works to do this using arrays, but...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back