enters

Hi Guys I have the following code Cells(LR, 28).Value = txtCNum4.Value In my useform txtCNum4 is a text box name Lease Period What i want is when the user enters a number let's say 10. vba inserts 10 cells after Cells(LR, 28) and i also want vba to add a heading month1 to month10 to...

I have a spreadsheet where a whole team enter data, and it's often not in date order (e.g. Mary enters 15th October, then Sally enters 7th October further down etc). On a separate sheet I would like to automatically list under each month the dates that have been scheduled, but in date order...

ok, I am sure I was doing something stupidly simple wrong. but I need to get results based on an entered data point. example in the spreadsheet: enter data in C16 search column C for the first repeat of data starting at current entry(C16) if found(C9) pulls data from column G(G9) and enters...

I have a numeric cell, that I would like to be able to enter "-123" and the cell displays "-1.23" or if the user enters "-1.23" the cell will display "-1.23" is this even possible? Thanks

Hello I am pretty new to VBA and I have a question In column A i have thousands of IDs, in column B their prices I have a userform where the user enters ID in textbox1 and in textbox2 the prices is retrieved. My question is if there is possible to enter multiple IDs in textbox1 and have...

I have a filed on form that is formatted as currency with a default of zero "0". When the user enters the field to enter an amount, the cursor appears in front of the defaulted value of 0. So when they start entering a value - less say "17" it shows as $170 not $17. When they hit enter it...

=IF((OR(B8=0.375,B8=0.5)),CEILING(C8*D8+E8+F8*0.057+G8*0.094+IF(AND(B8=0.375,H8="X"),0.328125)+IF(AND(B8=0.375,I8="X"),0.453125)*0.25,CEILING(C8*D8+E8+F8*0.069+G8*0.125+IF(AND(B8=0.5,H8="X"),0.4375)+IF(AND(B8=0.5,I8="X"),0.59375)*0.25,0))) The above formula outputs "0". How I want this formula...

Morning, I have a spreadsheet in which I have inserted a textbox, so that data input is easier for the user (similar to writing in Word). I have set a default size for the textbox, but if the user enters more text than the current default height of the textbox then the text at the top...

Hi Guys I have a userform with 3 textboxes on: TextBox1 = the user enters gross value TextBox2 = user enters VAT Rate as a number [not a percentage] TextBox3 = Calculates the Nett Value If I use this code: Private Sub textbox1_Change() TextBox1.value = Format(TextBox1.value, "Currency")...

Hi Guys I need to have a textbox that shows the nett value before VAT from a Gross value I have a UserForm with the following textboxes: TextBox1 where the user enters the Gross value TextBox2 where the user enters the applicable VAT Rate [default is set to 20] TextBox3 is to contain the Nett...

Hello, The following line of code Area.CopyPicture Appearance:=xlScreen, Format:=xlPicture Doesn't work when the computer enters in standby mode. Can anyone help me? Thanks!!

In cell C2 of sheet1 the user enters the row number of the header row for the 'new_report' tab. I need to count the number of header columns based on which row number the user enters (i.e. user enters 3 then COUNTA row 3, user enters 5 then COUNTA row 5 etc.) The formula below was my attempt at...

Hi Id like to format a cell so that it formats it so that a "/" is shown between the 4th and 5th digits.. User enters 234501 Cell is formatted as 2345/01 Thank you in advance Al

I have been fighting with SUMIFS for the last few days and finnaly figured out WHAT was wrong but I am hoping someone can tell me WHY When i put together the table below I typed "Week_01" into cell M6 then I grabbed the little corner doohickey and dragged to the right This Auto enters...

<tbody> A B C D E 1 1 2 3 2 Anderson 1074 1261 1329 3 Camp 1118 1313 1384 4 Gregg 1079 1268 1336 </tbody> Question: If user enters the number "1" in a cell and enters "Anderson" in another cell, I want to return 1074 based on the above chart, but if user enters...

Hi All, I'm trying to create validation rule where only value in upper cases "MUKESH" would be allowed in field. this is what I'm trying with - Is Null OR Not Like "*[!a-z]*" but not seem to be work . Note : I know I can format field with ">", so that whatever user enters it will turn into...

Hi, I am looking for a code that will create a new Outlook Task when someone enters a value in a specific row. I use below code that creates a automatic email when someone enters data in row D and would like the exact same result except that it creates an Outlook Task instead of a simple email...

Hi I have a list of book titles in A1:100. In cell C1 the user enters a string of one word (and, if possible, two words separated by a space*) In cells D1 to D5 I need formulas to return the full book titles that contain the word or words the user has entered. *e.g. if "Journey to the...

Hi there guys, Been a while since I've been using excel and the brain is a bit rusty.... I'm Just trying to get a formula right so that if someone enters a name, the matching phone number comes up next to it... breaks down like this.. I have a column A with names and a column B of phone...

Hi, Please can someone help me? I would like code that once 1 cell has been entered in a range, the rest of the range enters a "C". So basically my range is D5:D15 If the operator enters a "N" then nothing happens. If the operator enters a "Y" then the rest of the cells in the range auto...