userfom

I built a UserForm on Windows, and for Windows, but with the intention of it ultimately working for Mac. I can't find many resources on developing UserForms for Mac, so I'm hoping I could get some suggestions as to how I could build a working Mac version. Here is a link to my Worksheet...

Hello I have a Userform that I am using to enter data into cells in a row. One of those cells is to include a date. I want the date to be formatted "YY-MM-DD" (January 5, 2020 = 20-01-05). When I have the value from the userform entered into the cell it does not act as the date that it visually...

Hi, I want to copy a range and paste it several times via a user form using a text box. It already works fine but I can only copy and paste that range once. I want to paste it as many times as the user wants with the textbox input. Thats my code at the moment. I would apreciate some help...

The useform startup position doesn't seem to take into account of the ribbon. I couldn't find a way to test if the ribbon was minimized or not. Tried to position relative to first row, but this still considers the ribbon, same position results if ribbon is minimized or not. Private Sub...

Hello, I need help in a very simple schema in a userform. What i need to do is to set up 2 comboboxes, the first one shows the countries, and the second one shows the cities of the countries above. (I want the correct cities to show up when i select the country above) I have just 2 countries...

Hello, I'm new to VBA. I have written a code that hlookop value in table when I press option button . Sub XS() If UserForm1.ComboBox1.Value = "" Then Worksheets("Sheet1").Range("E1").Value = 0 Else Worksheets("Sheet1").Range("E1").Value =...

Hello, I am new to Excel VBA, so please bear with my explanation. I have a User form with a Multipage setup (3 pages) and on the 1st page, I take the user input for No. of Departments using a Spin Button. Now I want a Combo Box to be populated based on the number selected in the Spin Button...

I'm trying to open a specific folder on a network based on the information entered by user. This entered information updates the header info, so cell values won't be accessed. The input corresponds to a number and a name, that would also be part of Folder Name and Workbook Name as well. I've...

I am trying to populate a UserForm ComboBox drop down list and it is also picking up the blanks that are in the column. How do I remove the blanks in the ComboBox on the UserForm. I have not found any code that has worked for this issue.

Hello, I've built an excel userform for my staff to add orders. But I would like to have the userform look online for the current exchange rate from USD to CDN. Is this possible? Thanks

Maybe I am not using the correct search terms, but I am unable to find an answer to this design issue. I have a userform (several in fact) that have a multicolumn list for records related to that form. I have a good amount of validation that I run on some fields utilizing the Cancel function...

Hi, Hopefully someone on here is able to help, i am not familiar with VBA . i have a leave spreadsheet with 12 tabs for that calculates staff leave, their name in column B and the date in row 2. This workbook is read only for staff and only editable for managers. what i would ideally like is a...

Hi All, I hope so one can help me, I have a UserForm with 9 Checkboxes (1 to9) and each Checkbox relates to a specific range of cells from 9 separate worksheets. I have set the ranges to Rng1 to Rng9 I want to add only the ranges (Rng1 to Rng9) that have been checked as true to an array...

Dear All, I have a userform with a button that opens another userform. Once the user has finished to use the second userform, he is supposed to close it with the X at the top right. This unfortunately closes also the first userform. The first one should remain open and the user should be abele...

Hi, I am trying to speed up data entry on my spreadsheet and would like to know if it is possible to jump out of a cell edit/typing mode (i.e. when the cursor is showing. Sorry not sure what the correct term is) in VBA? Currently I have to click on another cell to be able to use any of my...

Hi All, I have spent a few days searching / trying to make this work, but its just not working. This is the first time I have posted, so I hope this makes sense. I have four comboboxes in a userform. The first one looks through "Column A" and lists all individual items. Combobox2 lists values...

Hi guys, I have the below vba code for a userform. Every time I select the list, it keeps repeating itself and keeps getting longer. Please review the below code and provide suitable solutions. Thank you. Private Sub cboClass_DropButtonClick() 'Populate control. Me.cboClass.AddItem...

Hello! I am trying to create a user form that makes a user select a name from a Listbox and two options from checkboxes and returns the average of "days" and "amount" for that name selected from the listbox . I'm new to VBA and having trouble setting up the code to do so. Does anyone have any...

I've made database and now I want to delete any item and from the database and shift the cells up.

Hello, Im trying to get the text from a textbox to the last row of a table. I do not want to add a new row, the row is already created by the macro and filled with data from column 1 to 6, I just want the text from the textbox to go in the last row of the seventh column. Here is the code I'm...