blah

  1. I

    Conditional formatting matching more than one criteria

    Hi All I have been struggling with this one. I can do it if its a duplicate but not with different criteria. Basically I need to get a formula, preferably using conditional format ( so it colours the rows) I want it highlighting if as example Mr Jones had bread, doughnuts, and cake in the same...
  2. D

    Runtime error 424 Object Required

    Hello, A "double click" on any of the cells in Column B "Trip" launches a routine which produces the following error at present. <colgroup><col><col><col><col><col></colgroup><tbody> Date Trip Order No. Issue Detail 31/08/2019 60A 1 Issue 1 blah blah blah 31/08/2019 39B 2 Issue 2 blah...
  3. K

    Userform Code

    I am very new to Userforms and have learned all I know by researching examples. I'm thrilled with a userform I set up, but can't figure out one final detail. I have loaded a combo box with student names pre-loaded a worksheet using the following: Private Sub UserForm_Initialize() 'Empty...
  4. M

    Renaming Charts/chart objects??

    I've got a chart embedded in a spreadsheet that is called 'Chart 1'. I've got some code to run and set the trendline which seems to run ok. Dim STPChart As Chart Set STPChart = Worksheets("Detector1_Report").ChartObjects("Chart 1").Chart With STPChart blah blah blah... However, I don't...
  5. C

    Counting commission & formula /text

    Good Morning I would like to combine text and formula's for example it would star Hi, and then take the info from the sale sheet by date cell B2 then continue with text blah blah blah and then insert another formula from the sale sheet by date cell H2 and then continue with text blah blah blah...
  6. S

    Extract substring from text string folllowing keyword - formula required

    Hi - hoping some expert can help me with a text search query I've got a column full of text entries. What I would like to do is extract x number of characters after certain keywords. So for example. keyword 'DOB: ' then bring back the next 10 characters So if the below is the text in cell...
  7. S

    calling a userform and reverting back

    I have a section of code below from a much larger piece. The section of code worked when using an input box to acquire a userinput. However, I'd like to have userform replace the inputbox. I've tried just using a userform and inserting the line (as seen below) but that didn't work. I need the...
  8. theboyscout

    Schedule email from list

    Hello, I'm trying to create a script that would search a folder, find the last inserted spreadsheet, locate a field and if that field is > 0 send an email. And this is to be run weekly. <tbody> F L O Descr Email Available_Spots 60749 jon.snow@got.com 1 </tbody> I've scraped up a...
  9. C

    Protected Sheet - Nag error when VBA modifying cells?

    First time doing this... I've created a script at this point that is doing what I want. I've also applied this bit below to the Sheet tab in order to cause the cells to be updated automatically any time certain cells are modified: Private Sub Worksheet_Change(ByVal Target As Range) If Not...
  10. C

    Macro to capture/count data in a column

    Good Morning! I'm tryig to figure out how to create macro that will review a column and list and count values in the field. Example The Column will hav "Unit" as defned by House, Apartment, Barn, whatever. My goal is to try to run something that go through the column and capture all values...
  11. baitmaster

    file corrupting when saved

    I have a large and complex file currently open and working. I've been saving regular versions v1.1, 1.2 etc throughout the day. When I attempt to reopen any of these I'm getting the error "we found a problem with some content in ..blah blah.. do you want to repair?". The repair tool doesn't work...
  12. S

    Find numbers before unit of measurement in string

    Hi, I've got what seems like a simple conversion task that I'm having trouble puzzling out. I have a column of product descriptions (text/html) that contain measurements (i.e. "Medium - 6.3cm x 7cm") and I need to find and convert them from cm to inches. I'm having trouble figuring out how to...
  13. M

    VBA Range syntax help

    I'm wondering if someone can point me in the direction of a resource that describes the syntax of different combinations of ranges like below. I have trouble remembering the right syntax for concatenating the different items, and I'd just like to bookmark a page that has examples of these types...
  14. E

    Splitting a table and formatting problem

    <tbody> A B C D E 38 No OP MO Txt Co 39 112254 10 04 FSR Yeah ABB 40 114554 20 04 FLB Whatever ABB 41 144754 10 04 BBA Etc Claptrap 42 112266 40 04 KKT Blah Claptrap 43 123457 15 04 JJF Blah Claptrap 44 111365 10 04 MMN Blah Gardner...
  15. USFengBULLS

    Fill Certain Cells on Form Sheet based off Data entered in table on Another Sheet

    Hello All, I have another question concerning filling data from one sheet to another. Sheet 1 I created is basically a transmittal form, Sheet 2 is a list of sample materials that will need to get approved or rejected once sent. The user will go in at the start of the job and fill on the sheet...
  16. L

    selecting multiple rows -vba

    Hi the code below is to type blah in cell a43 then hide rows 25 to 70 for sheets 1 to 5. it works only for sheet1 and then i get error message "selection method of range class failed" Sub fivesheets() For i = 1 To 5 ThisWorkbook.Worksheets(i).Range("a43").Value = "blah"...
  17. J

    Adding attachment to email - Runtime error 438

    I have this macro that email's a specific range from an actvive sheet that works perfectly until I try to add an attachment from a file path on my computer and this is where I get the 438 error. What am I doing wrong? Any help is greatly appreciated. Sub Email_Test() MsgBox "Email will be...
  18. K

    Macro to sum selected cells in a row and repeat for all rows in a column with values

    To all, I'm looking for a macro that will allow the user to select multiple cells (up to 5) in a row (Lets say E10 and G10) and then add the sum of those two cells into the left most cell selected (this will usually be the first cell selected but it's possible the user will select the calues...
  19. K

    Macro to auto highlight a column if a cell contains specified value is in a row

    To all, I'm looking for a macro that will start in cell D6 and see if the cell contains the word "Custom" anywhere in the cell and if so, highlight the column to the last row with data in it. I then need it to move over to D6 and repeat until it encounters the last column with data with it at...
  20. M

    printing out a textbox contents.

    I have rather large textbox where a user can type notes and use the return key for spacing, etc. textbox1.value is (example) 1. Problem1. Solution is blah blah blah. 2. Problem 2. Solution is blah blaha blah. 3.etc 4.etc 5.etc The question is how I can parse this line by line to my...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top