enters

  1. R

    insert cellls vba

    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...
  2. C

    Putting data into calendar format

    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...
  3. M

    vlookup help, can this be done? (cells in J&K filled with info from G&I if data in C is a repeat)

    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...
  4. F

    Number formating

    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
  5. H

    Application.Match

    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...
  6. gheyman

    Access: Key behavior in Field - Cursor

    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...
  7. W

    Problems with multiple IF statements into one Formula

    =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...
  8. HomeTek

    Auto increasing cell height based on ActiveX form textbox input

    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...
  9. T

    Formatting 2 TextBoxes as Currency

    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")...
  10. T

    VBA to remove VAT from a Gross Value

    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...
  11. A

    CopyPicture isn't working when the PC is standby

    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!!
  12. E

    Dynamic COUNTA function based on user input (row #)

    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...
  13. M

    Cell Custom Formatting

    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
  14. J

    Interesting Problem

    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...
  15. R

    Return value based on information in chart

    <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...
  16. MUKESHY12390

    Table Design - Vaildation Rule

    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...
  17. B

    How to create an auto email as Task from excel to Outlook with VBA

    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...
  18. D

    Return valuse that contain a string or two strings

    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...
  19. C

    If Vlookup for data base matching

    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...
  20. D

    Only allow 1 entry in a range. After entry the rest of the range auto fills

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top