userforms

  1. M

    My code works of one Userform but on the other it says "File not found"

    I have two separate user forms of which the only difference is the place in which they put the data. The Userform "TaskForm" works fine but when i copied across the code to Userform "AssessmentForm" and changed the relevant details it says "File Not Found" Followed by "Run-time error 361" The...
  2. A

    ComboBox Scroll Bar Width

    Hi All, I simply need to know how (or indeed if) the combox scroll can be made wider. I have built a userform to be used on a touch screen computer and have sussed making the actual button bigger but the scroll bar is very narrow. Is there a way this can be made wider? Screen shot below to...
  3. G

    Blank Userforms for some users

    Hello, We've built a large input form to help handle manual data input into a spreadsheet. However, for some of our users, the user form is entirely blank (either when it loads from clicking a command button that ".show"s the form, or if they look at the form in the VBA window). All users are...
  4. S

    UserForm ListBox with 2D Array and Match

    Relatively new with VBA and doing my best to learn it. I have a userform which has a listbox. To this I would like to add some type of Match function so that the listbox only displays the rows in which a certain value is displayed. For example, the project ID is displayed in Sheet1 cell B1. In...
  5. L

    Userform search

    Hi, I have a table with 45 members and let's say 100 columns. Each column is a date and members will have a negative figure within the cell referencing their name and the date if they have a holiday. (EG John Smith is off on 12th June so he would be -8 in cell H22). I want to be able to...
  6. K

    VBA Userforms Approach

    Hello All, I am new to VBA so apologies in advance for any "noob" questions. I recently (2 weeks in) started watching YouTube videos and reading various books to learn VBA to increase efficiency. I am reaching out to get thoughts on my planned approach and any resources that anyone can point me...
  7. D

    Next Row VBA issue - Beginner

    Hello, I am really hoping someone came help me. I have been trying to teach my self VBA using YouTube etc as my teacher. I have working on this Data Form, I am getting there but I having one issue. I have tried heaps of things and this is the closest I have come to it working. I have set up a...
  8. M

    Check boxes on a userform

    I have created a template sheet that I will be using for my team to create quotation. I have generated the first part of the form that completes the pricing part. I have a userform that I want to use to select different conditions to a quotation. I want the user to be able to tick/check the...
  9. C

    Loop through text boxes in a page

    Ok, I have working code that looks like this: Private Sub CommandButton39_Click() Dim objWorkbook As Workbook Dim i As Integer Dim arrIn As Variant Dim arrOut() Dim j As Long Dim counter As Long Dim outRow As Long Dim sUser As String Set objWorkbook = Workbooks.Open( _ "C:\Documents\Data.xlsm")...
  10. G

    Userforms resizing and reformatting on different monitors

    I have a few userforms on a sheet, but when I use them on a different sized monitor, they resize (often much larger) and the contents are not organized well like I have them set. As soon as I go in the VBA Editor and resize them back to normal, they take on all their old formatting, but I was...
  11. A

    What did I do to the scroll bars in my UserForms?

    I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've...
  12. I

    Color codes in UserForms

    Hello all! I am trying to get more into making UserForms and the limited color choice is starting to bother me. Is there a way to convert hex color codes to what ever this is, &H80000012&?
  13. H

    Sharing Excel W/ Macros and Userforms

    Is there a way to Share Excel with Macros and Userforms enable using Excel online that exceeds 5 mb?
  14. M

    Create "if then" statement in button click

    So what I am trying to do is when a button is clicked, depending on if a certain cell contains a text, will bring up a certain userform. So if "I6" has a date in it, userform1 would show. If "I6" and "I10" have a date in it, then useform2 would show. If "I6", "I10" and "I14" have a date in it...
  15. T

    VBA to filter between two amount I put in a popup box?

    Hi Everyone, I want to create a macro that asks the peson to insert tow amounts into a messagebox or any kind of popup box then filters by this? I know how to use userforms so that would do me fine. I currently use this Sub Filterby1() Sheets("Master").Unprotect 'Password:="august"...
  16. M

    Userforms shrink on successive openings of an Excel file

    Hi, I've run across the weirdest bug ever and wonder if anybody recognizes it and have any input. In an Excel VBA-project several years in the making, after some recent automatic update to my Excel 365 desktop version, all userforms are rendered smaller and smaller on successive launches of the...
  17. N

    Userform data arrays

    Hello Excel Friends,<br> <br> I have a user form that currently publishes the data to a database sheet in one row, however, what I need it to do is publish the data vertically instead of horizontally, but I need 2 of the form sources to be replicated in each row.<br> <br> My current user form...
  18. L

    merge two workbooks

    Hi good people, I have two workbooks which both contain at least 10 sheets each, and all sheets contain vba. Both books contain buttons, and userforms, etc. I have manually copied all sheets of the one book into the other, only to find that all buttons, userforms, etc, renames. so, when I press...
  19. G

    Pop-up UserForm in an exclusive computer.

    Hi everyone, I have this Workbook with several UserForms. The Workbooks is shared between 2 or 3 Computers simultaneously. It is shared using the old way not the cloud. One of the UserForms will work just like a Pop-up message in one especific computer. But, since it is just one workbook, I...
  20. M

    Macro works on first go around, then doesnt work correctly until excel is closed and openned again....only to work once.

    So I am trying to create a button that opens a userform thatasks questions on what the user wants to do. It is kind of hard to explain so Iam going to try to insert screen shots of what I want to happen. Below is part of a table that is created on the main pageentitled “Status Sheet.” <tbody>...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top