userforms

A while back I developed a choir music library application employing VBA and Userforms; it is successfully running on a Windows platform. I've been asked to rework a copy of my application for another choir, but it needs to be run on a Macintosh platform. Is this feasible? Are there...

Hi I've been adapting a userform I found online, however it is based on creating and filling in a new row each time. I need to change it so it always fills in the same cells then I have another macro to save it as a pdf to send to the customer. Just trying to make it nice and simple so there...

First, thanks for the help. I tried to research the answer first, but I don't think I was phrasing my question correctly. I've looked at arrays, and worksheet funtions, and I'm not sure how to proceed. Using Excel 2010. I have a table with many columns, but for this I'm only using 3 columns...

Hi, Hoping someone could advise me here. I have an execl spreadsheet preloaded with data on multiple sheets. I am currently using multiple userForms to display the data. On userForm1 i have two listboxes. I move values from listbox 1 to listbox 2 using a button called 'Select_cmd'. Prior to the...

To avoid confusing some elderly volunteers who are going to be entering data into a statistical gathering application, I want to minimise the background Excel application window while displaying userforms for the data entry. I have the necessary code for minimising the application window, but...

Hey everyone, i am currently working on a project where i have to create a userform with multiple options to select from. These options include Option Buttons and ComboBoxes. Based on the selection in the userform by the user, the code should look for the item which matches the selected...

Im trying to recreate a type of userform I made in Excel for use in Word. The form launches and the user is able to browse for a folder to convert files of a specific file type (in this case .doc files) to PDF. The userform stays open, i have a progress bar i want to display, while the files...

Hi All - I have spreadsheet that lists different tasks the user may want a support team to complete. Ideally, the user can click a button next to activity name which would open up a userform displaying certain options, fields for information,etc. There would then be a button at the bottom of...

I created a userform with typical label, text, combo and list controls. These controls are divided among several frames. I ran the userform to view and when I returned to design mode to move these controls around, they wouldn't move. I can resize them and change the caption, but can't move...

Hi I am using a user-form to allow a user to log weights from a set of scales. I have a combo-box which allows them to choose a formula. When they choose an formula I display the :- amount, the batch#,expiry date. on labels on the userform. everything is working apart from formatting the date...

Hi all, My issue comes about when I'm trying to copy data from certain rows within a sheet, where the location of the rows is directly related to the value during the particular loop process. However, this gives me a Method'Range of object'_Worksheet' failed error. If you're confused, here's...

Hey everyone, sorry if this answer is already out there, I have been searching for a week now without any luck. What I would like to do is have a UserForm that displays a check box to each item in a list, and if the column next to the item has a "Y", then the checkbox would appear already...

Hi, I'm trying to create a code for user forms that will force a user to input a value in EITHER one cell or another. i.e. I have a userform for data entry for employee pay, load, etc. and I am am trying to leave users with the option of entering hourly wages along with # of hours worked...

Hey everyone, I'm trying to figure out how to open a userform with textboxes already filled in based on values in a cell range. I can't seem to figure this out for the life of me. Thanks

I have a few userforms that you can click on buttons and to move back and forth using hide and show. here is the problem: Your on UF1 and click the button and go to UF2. Then you move that window, and click a button back to UF1 the window jumps. Move either window and you end up clicking...

Hello Everybody, I am a beginner in VBA programming and I have to make a Userform for entering data in the specific places(in a table) in the worksheet. But when I enter a number, it changes all the cells to that number. I can't find my error. I would be appreciated if someone could...

Dear reader, Normally I would research this and do it myself however I am greatly pressed for time. I need to set up forms for for getting data into two excel worksheets. The users mess up the data and enter it incorrectly/do not enter all the required data, most of the time. My intention is to...

I have a made a userform with 8 groups of 1 Combobox and 2 Textboxes. I want to create required fields, so that if one of the input boxes within each group is filled in, the rest in that group must be filled in as well. Here is what I have coded: 'Group 1 If cmb1.Value <> "" And txt2.Value...

Hello, I've just started using the VBA and am trying to create an Excel UserForm, which lists all visible Sheets in the current file (doesn't list hidden ones) andcreates a checkbox in front of each Sheet name, which will hide/show the Sheet, depending on it being true/false. The Form must be...

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...