userforms

I'm trying to set up an app that's going to use multiple user forms, and I'm running into questions using me.Hide and Unload Me. Let me try to simplify the code and describe what I'm doing. I have a frmMain_menu with various buttons on it. One of which will let me choose from a list of risks to...

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

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

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

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

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

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

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

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

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

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

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

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&?

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

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

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

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

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

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

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