userfom

Hello all: I am creating a VBA workbook with UserForm to allow users to input data. I do not want the workbook to be visible to the user and have used "application visible=false" code. Everything appears to be working just as I want, however, I do not want to add a button/code the userform to...

Hello Everyone, I have a userform in which i made two combo box, below are the name's ComFruits_Change() ComVeg_Change() Both combo box having informations like below: Private Sub UserForm_Initialize() ComFruits.AddItem "Apple 1" ComFruits.AddItem "Apple 2 "...

Hello Everyone, I am working on a Userform and need your urgent help on the same. Purpose of this userform to open relevant workbook which are attached in workbook as Object. I have to hide that sheet and sheet name is objectsss In userform I made on combo box and gave name - ComFruit...

Hi, I have looked into this for quite sometime but I haven't been able to get anything to work. Can someone help me please? I currently have a check box which when ticked, returns the date in the same cell (Q7). However, I want to restrict who can check/uncheck this box with a password...

I am working on an inventory project, where I need to use a UserForm. Sadly I do not know how to code in VBA. I’ve gotten quite far with tutorials online but I am not in a dead end. I need to get the + & - buttons to add a quantity of 1 to the database spreadsheet( I have the buttons named...

Hi, I'm attempting to prioritize what is selected first in List box for example; I have source that has 1,2,3,4 The user will select 2,1,and 3. When the output comes out into a cell, I want it to show 2,1,3 not 1,2,3. Here is the code that I have; however, I'm getting a subscript Out of Range...

I have been researching and have gotten close but not exactly what I need. Please help me code with the below in my first Userform. Combobox #1 - Named "ComboBoxlLocation" Combobox #2 - Named "ComboBoxCopy" Combobox #3 - Named "ComboBoxMedia" Combobox #4 - Named "ComboBoxPricing"...

Hello, I want to develop a user form in which user be able to drag and drops the controls (Labels or Text boxes) from one specific frame to another frame. Can anybody helps me on this? Is this possible in VBA excel and is this handy? the actual project is bigger and have the login and log...

I have a user form with check boxes and they each have a title. Plant Manager Foreman Supervisor etc. I would like for a user to be able to select everyone that was there. when the user hits the submit button i would like the code to be able to look in column A for the first cell that has...

Hi All, I need you help with the Listbox in Userform, I have two columns in Excel Raw file, Column A has got categories and B has got the unique data. I want to have all the Data from Column B in the list box, which falls in the category (From Column A) mentioned in TextBox1. kindly assist...

Is it possible to create a data entry form update in real time just like MS Access, also it should retreive and edit data from the table aswell. Or do I have to use MS Access or another software for this?

I have userform text boxes with dates in them in the format "dd/mm/yyyy". I want to be able to show however only the "dd". The issue is that if I use this code: Label20 = Format(Label20, "dd") Then the actual contents of my data gets lost. Ie using the code msgbox label20 returns only the...

Hi all. Long time listener, 1st time caller. I am still learning a lot every day with VBA, having only recently returning to a position that requires me to use it again, and I didnt know much before! I have a UserForm which is populating data entered into 'row 2' on 'sheet 1' which I need to...

For calculating a person's age, Courtesy of Ken Getz, Mike Gilbert, VBA Developers Handbook: Function dhAge(dtmBD As Date, Optional dtmDate As Date = 0) _ As Integer ' This procedure is stored as dhAgeUnused in the sample ' module. Dim intAge As Integer If dtmDate = 0 Then...

Hello I am new to VBA but did a lot of research and a lot of readings in order to create a VBA to my employer. I have written the code but having some small bugs that you guys might be helpful. Purpose of Code: When you first open my excel sheet, only three pages will be visible( Sheet 1,2 &...

I am fairly new to VBA but I have some code I have made up Userfrom looking at examples. I have a form into which a user scans Name and equipment. I would like once the equipment is scanned in that the form then offloads the information to the worksheet and blanks all the text boxes on the form...

Hello, I've been slowly building out multiple user forms through the help of the community. I need a Delete Command Button in my Search User Form that loops through my worksheet and deletes multiple rows that equal the Project Name selected in the Search User Form. For example, user selects...

Hello (operating on Excel 2007) Hope someone can help a newbie here. I've set up a userform(named Reports) to run a report from an Excel database(named Data) which will then populate an excel spreadsheet(named By Representative) in the same workbook. On the userform(Reports) I have 3 search...

Hello Everyone! Hope you all are fine. First, I want to apologize if there's already a thread about this subject, I searched a lot and didn't found anything that could help me with my problem. So, I'm trying to use VBA userform to look for two criterias from my worksheet. <tbody> A1 A2 A3...

Hello, I am wondering if it is possible to add a countdown timer to a userform. Here is the design that I had in mind: a) Insert a textbox on the userform displaying the countdown b) Allow the user to interact with controls on userform while the countdown hasn't reached 0 c) Take action if...