userform boxes

Hello :) On my userform i can watch or change all textboxes. if i click the update button, all (!!!) textboxes are stored in the database, whether they changed or not change... how can i make it happen that after changing a few textboxes, only those changed textboxes are updated to the...

Dear Team, I want to calculate age based on Birthdate & Current Date in userform1, i have already created below 3 components, list of combobox1, 2 & 3 for birth date month & year respectively, __done Textbox1 for currentDate,__done & textbox2 for age calculating. ???__question Please help for...

Hi, Below is a pic of the SOR Validation userform for explanation. Code is below that. I am breaking the issue into small parts. I would like help with the following. Lets say, as is the case in this picture, a user has selected Carpenter_Joiner in first dropdown then CABM03 in the second. This...

I have a macro that runs about 15 other macros. I have a user-form that lists the macros, how many tasks in each, when each macro starts (Tick + "running"), when it finishes (Tick + "complete") & a % of overall progress. All of which are textboxes linked to a sheet which is updated by each...

Hey Guys, I have series of sub functions running through, while running I need a User form to pop up asking user to select pivot filters. I've broken it down to steps while running sub. Step 1 (Macro Running): I will be creating a pivot table (say PT1) with all pivot items selected initially...

I don’t see any posting on this issue anywhere! i have a .xlsx that has two user forms- 1 is to enter new data which can be recorded to a worksheet and the 2nd is to source the worksheet and edit a particular row of selected data- My company uses win7. The problem I am having is as follows-...

Hello guys, I have written a code which creates an array of textboxes (for example. 6x3) according to the user on the userform. But i cannot use these textboxes for further procedure because they are created dynamically and not in the design mode. There is no textbox_change() or...

I am passing dates into variables labeled "Bx" using an increasing counter. There will be 45 of these variables so it will go Bx1 , Bx2, Bx3....Bx45. Code for this part: do while k<>46 Dim Bx(0 to 45) blah blah blah Bx(k) = blah blah blah k = k + 1 loop This works when defining variables but...

Hello: I am trying to insert selected Data from RowSource list into Textbox2 in Userform1. My Rowsource list has two columns and i like to have information from both columns be inserted into the Textbox2 with possible dash between them [12 12345 - Test Text]. However, i am only able to get...

I have created a userform and it has several textboxes where the user inputs numbers (these will be financial data prices). In one text box the user enters the Price of the asset. This price can vary in format: it may be £2.27, $123.56 or £64.5902. I want the userform to work out how many...

Hi, I am begineer in vba and finding very attracted to vba and excel. I have a column A with multiple entries, however some entries are repeated due to different criteria's in column B, and have some entries in column C,D,E. Now, i want to have a userform which will have input as a text from...

Hi, This is my first time posting on here. I might be in over my head but I am sure there is someone out there who knows the answer. I have a userform with a textbox in it. I have the textbox set to multi-line. Whenever I run the macro I've created It will take the input, find the spaces...

Hi, I have a userform with 2 textboxes that a user can enter values in. When I step through the code, WOQty is "0" and WONo is "" even when the textboxes have values entered into them. I declared 'Public WOQty as Integer' and 'Public WONo as String' in my UserForm and then tried in a Module and...

HI Excel guru's I have a userform which populate a spreadsheet part location date I have created another userform part date I would like to enter the part (unique alpha numeric) which would automatically find the row and then update the row in the spreadsheet, with a new date in column 4...

I have some coding experience, but never attempted anything like this in Office 2010. Essentially I have an excel worksheet functioning as a database of service records. Nearly 10K rows/records, with 'Customer Name, Contact, Phone, Invoice #, Product ID, Model, Desc, Make, Lot#, Service Date...

Hi All, Bit of a newbie so apologies if this is trivial. I have a userform with several textboxes. The userform is used with a touchscreen and I have setup X10 buttons labelled 0-9 in the form. I want the user to select a textbox (either textbox1; textbox9 or textbox10) and press eg button '9'...

Hi everyone... I have a userform with several ComboBoxes, TextBoxes and ListBoxes. If I select criteria from say ComboBox1, lookup the value selected and wish to populate another ComboBox (say ComboBox2) with data found, How could I prevent the ComboBox2_Click event from executing? In my...