user form

Hello, I have an excel spreadsheet workbook that has multiple tabs. The 2 tabs that I want to focus on is "Requirements" and "Version Control." When a line on the requirement tab is in need of being changed I would like a macro to be pushed and then have a user form appear that has the...

Hi all, I have a small user form which shoes a countdown in seconds, then it closes and goes back to the main Routine and executes some staff (this repeates several times). Now my propblem, I have a cancel button on the form but I can not press it, resp. nothing happens, any idea why. I want to...

Has anyone created a User form directly from VBA?:confused: Is there any type of Auto template that can create the core of the user form for you based off an existing Excel sheet? So if you have a a sheet that has 6 columns and two buttons, it would be really cool if there was a way to invoke...

Hi all, I am relatively new to VBA and am trying to learn it's limitations. I have managed to create a user form that creates a new tab with the name entered in the user form text box. On this new tab, is there a way using VBA to have it equal to the values and formatting of an other tab at...

Good Afternoon - Very new to VBA. I have managed to create an advanced userform with multiple values, text boxes, combo boxes, multi select list boxes. I can copy this data into excel. I can also retrieve the data for the Text Boxes, and Combo boxes back into the User form search for a...

I want to make a form which behaves like the standard data entry form but customise the layout. Things I like about the Data Entry form: * the ability to scroll through the data * it displays the data currently in the cells * I can make changes to the data and the change is committed to the...

Hi all, I have a userform which is being built as a calulation tool I have a combo boxes and text boxes that are dependant on each other, once filled in there is a button that should calculate a range of values dependant on 1.) The value in the text box 2.) The selection in the corresponding...

I am creating a personal finance tracker where a user enters their purchase information in order to track their daily/weekly/yearly spending. Upon submitting the User Form, the information simply populates a raw data source that feeds into many pivot tables and charts. For my own personal...

I am completely new to VBA and have learned quite a bit in the last week by working slowly on a personal project of mine. I have most of the essentials set up, but it is imperative that I provide the user the ability to undo a data submission when using a User Form. My submission code is as...

Hi all Is there a way to run a user form in a shared Workbook??

I realized I should have put Userform Combobox into the thread title. Sorry! I'm new to VBA but not new to coding or to excel. I have used multiple google searches and youtube videos (You're welcome Alphabet) to build vba code that will copy a template worksheet, name the worksheet using an...

Hi, I have a simple spreadsheet database where the second column of every row contains a hyperlink to a pdf. Each Hyperlink is unique for each row. I want to add a command button to a user form that when clicked, allows the user to browse to the correct pdf and embed it as a hyperlink into the...

I've used this board extensively for the past three months as I've learned VBA for a project I'm working on. This is my first post because I can't seem to find a workable solution, hopefully the Excel gurus here can help... I need a VBA code to delete a single row of data when the value in...

Hello - I am having an issue with my user form code. I am receiving an (Out of stack space error) The following code is pushing data entered into the user form to the corresponding excel file in order to calculate values derived from these inputs and then returning the calculated values back...

Excel 2013 Issue: the first textbox value is compared to if it is greater than the total value of textbox 2. The issue is, only the first number (left to right) of each box is evaluated...likely reading it as a text. Suggestions? The closest posting I have found is here...

Hello and thank you in advance if anyone can help me. I am trying to create a Button Click to open up a Text Box that can be Edited. And then I would like that Text Box to be placed on the active sheet. Nothing fancy. The goal is to have a place where employees that are viewing the page can see...

I am completely new to VBA and just kind of monkeying around with it trying to make a userform for a time sheet. I want to find a way for the user to select their name from a drop down menu to record time out (already have time-in under control). The name was added to a row when they recorded...

Hello, this is my first post. hopefully i can finally get some hkpe. Ive searched high and low for an answer via google, forums, youtube, you name it ive tried it. Anyhow let me give some background first. I have no previous VBA experience and all that I have learned has been int he past week...

Hello, This is my first post, so I apologize in advance if the format or content is irregular. I created a Userform in designer mode, inside which controls need to be added or deleted as necessary. The reason is due to the highly variable amount of data that may need to be entered (it could...

Hi, I have a user form that are supposed to open a worksheet. I use Private Sub CommandButton2_Click() Sheets("Rapport_Linjer").Select Me.Hide End Sub to open the proper sheet, but changes made in this sheet are made in the sheet where the form was opened, although I'm currently seeing...