user form

I am just learning how to create VBA's and need some help please! I have a worksheet that I am using to manage customer information. In rows "E" trough "T" are the fields for customer information such as customer name, address, phone,etc. I have over 1500 rows of information to keep track of. I...

hi all, I'm thinking of creating a user form to help me track notes and checking. I'm not a novice with VBA and user forms butequally im not a master and maybe not quite an intermediary user either haha. Basically i have spreadsheet sheet for estimating jobs. It has rows representing subtasks...

I have a workbook with 26 worksheets that could have data in a certain range of cells. What I'm hoping to have is a subroutine in a user form that will look at each sheet in a range of cells V5:Y39 and show a list with no blank rows in a user form. I will have a Button on each sheet that will...

Hi all, Apologies for the terrible title. I have a user form where the user enters the total number of hours they were at work for. In most cases it is 7 and everything is fine, however, for part time staff, when they enter 5.5 and click the submit button, the data that gets published to excel...

Obviously new to VBA. I've created spreadsheet with many buttons and text boxes, etc... Now, I realize I should have placed them on a User Form for better control. Is this even possible? Can I add existing buttons to a new user form? I've searched the internet and especially your site for the...

Hi, I have got very difficult issue for me and cannot handle it myself :-( Hope experts here can help me. First of all I need to say that I am not good in VB, I am doing sth only from time to time only using hints and manuals. Now I did sth which is very helpful for me, a user form which...

Good morning Everyone. I am creating a macro where users put something in a textbox, and it turns green after someone checks it. all i needed was for the textbox to turn green, but when i put in the code, it says object required. Sub Jira()ActiveSheet.Shapes("TextBox25").Select...

The code bellow goes through my list of NAEDs and if the NAED is on the list it should activate combo boxes if the NAED is not in the list it should not activate the boxes. once this code finds a partial match it makes the combo boxes available i do not want that. It has to match the NAED in...

Hi! This is my first time posting on this forum, but I will try to be as clear as possible -- I am brand new to VBA so I appreciate any help that you all can provide. I have been working on some code that consolidates data from separate workbooks into one workbook. Then, using the index and...

I've created a user form that uses multiple sheets in my workbook (workbook1). I want the user form to only access that specific workbook. But, when I open a different workbook (workbook2), the user form changes data in workbook2 instead of workbook1. It is changing data in whatever workbook is...

i have the following code, it loops through the check boxes within the user form. Id like to be able to have the message change depending on which check box is true. how could i adjust this loop to have a specific message per check box that is true and then keep going continuing the loop every...

i have a user form with three frames in it "full day", "first half", "second half". in each frame there are 7 check boxes, each check boxs represents a day. a user should be able to come in and check of which days they want and depending on which frame they choose it represent a full or first...

I have a user form with the following code Private Sub CmbStarting_Change() LblDayOne.Caption = Format(CmbStarting.Value, "D-MMM-YYYY") LblDayTwo.Caption = Format(CmbStarting.Value + 1, "D-MMM-YYYY") LblDayThree.Caption = Format(CmbStarting.Value + 2, "D-MMM-YYYY") LblDayFour.Caption =...

I have 2 wants (1) to make only select fields required for submission on my userform (2) to have a single Message box that contains all the errors listed. Userform details - Submission happens when the CommandButtonSubmit is clicked Required fields include textboxes, comboboxes and frames...

I have a user form with a combo box that has a mist of dates. When the user selects the date i would like the labels to change. EX: the user selects 6/18/2018 and the labels change to 6/18/2018, 6/19/2018, 6/20/2018 etc. EX: the user selects 6/25/2018 and the labels change to 6/25/2018...

I have a user form that dumps data into a sheet. at a future date a supervisor will type yes in an approved column if they approve the request. once they make the change in column F to "YES" i need to extract the data from that row so the data is columns A-E in the same row where F had the...

i have a user form that gathers some data. The following code continues to dumb the info onto the active sheet rather then sheet 13 (request log). i need it to populate the data on that sheet every time rather then on the active worksheet. Dim erow As Long erow =...

NOTE: I POSTED THIS A COUPLE WEEKS AGO, GOT SOME HELP BUT ULTIMATELY DID NOT GET IT WORKING. AND NOW ALONG WITH THE ISSUES BELOW, MANY OF THE SHEETS OR BEING "HIDDEN" WHEN ATTEMPTING TO GET THE USERFORM WORKING. QUICK BACKSTORY: Our line of work requires us to do a lot of documentation, the...

Hi Everyone! Sorry if the title doesn't make sense, I couldn't think of another way of describing what I am trying to achieve here. Currently, I am trying to create a UserForm which shall be used to log workers hours. I have a working copy, however when the user clicks save, the data is added to...

Hi Can anybody put me right on a 'Compile error: Sub or Function not defined' please. Have had my first try at a userform and have copied this from the web. The userform has many labels and text boxes and a few combo boxes. Basically i'm looking for the form to populate a table called...