vba userform

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. Alan_P

    Excel VBA UserForm - Easier way to Hide/Show TextBoxes/Labels based on ComboBox Selection?

    Hi All, Bascially I have created a UserForm that has a ComboBox and depending on the number selected I want it to show that number of Labels/TextBoxes... so if I select "0" nothing is shown, if I select "1" one set of Labels/TextBoxes is shown, select "2" and two sets of Labels/TextBoxes are...
  18. J

    Specify Click Action for Dynamic Text on UserForm

    I have a VBA userform with a grid of numbers, each of which needs its own "click" action. For example: [0 1 1 4 0 1 0] [2 0 0 0 0 2 0] These numbers are updated through other VBA functions. How can I create click actions for each of these numbers? Right now this data is created as lables on...
  19. B

    Userform Tabbing Problem

    Hi there, I'm working a lot with userforms at the moment, and want them to be as user friendly as possible. I'm having difficulty with tabbing, as in, if the user tabs the cursor doesn't neccesarily jump to the next box, rather, it jumps to the box in the order i created them which isn't the...
  20. O

    How to use VBA userform to sum accross worksheets.

    I have workbook that has a tab for each week in a month. I have used a VBA userform with a multiselect listbox to allow the user to select multiple worksheets to roll-up into a summary worksheet. My problem is writting the sum formula to accept the listbox's array. Here is my code. I have used...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top