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

    Import UserForms using VBA Code

    Hello Experts, Is there a way to import UserForms (located in separate folder) when I open Excel file ? Workbook_Open method can help but I'm not sure as how to call the Forms from that. Your help is greatly appreciated ! Thanks.
  18. J

    Userform to add data to specific cell in a form

    Hi there, Hope someone will be able to assist me I have a button that will copy one sheet and then create a new sheet with the copied content. Then the userform will also popup The userform then needs to add the content to the newly created sheet. I don't seem to get it to work Here is what I...
  19. J

    Passing Data between userforms

    I am having issues passing information between userforms and I have tried asking how to do this here but I think I was asking the wrong questions. Here is my quandry. I have numerous UserForms that utilize data created on another UserForm but I can't seem to get it to recognize the data so I...
  20. H

    Message Box

    Hi - Is there a way to have a message box pop up when the macro starts to run that just says please be patient? I've tried UserForms, but they stall the macro until you close them. Thanks!

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
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 "".
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