type

  1. B

    Count occurrences of text within cells - not exact match

    Hi, I have a number of lists with various versions of same items but want to count key parts of text within cell. For example: Column A Back bacon Smoked bacon Rindless bacon I would use countif(A:A,"*bacon*") to return the value 3. However I want to take this a step further and have a cell...
  2. L

    Time data type in vba

    Hi The code below worsk but I wonder why vBA does not have Time type. Is not Date and Time format different? I defined x here as a Date but then assign Time function to it. It did work but wondering why there is not Time type. Thank you very much Sub mytime() Dim xtime As Date xtime =...
  3. R

    Excel-built customer journey map

    Hi all, We're spitballing some ideas at work and want to see a map of our customer journeys. We have 19 different product types and want to see how they travel from one product type to another, or stay within the same product type each booking. I have no idea how to present this data in a...
  4. B

    Time format / formula

    Im trying to create a worksheet for tracking time and am having a little trouble with how I enter the time.. Simply I enter the start time in C3 and the end time in D3 and E3 (formula in E3= =D3-C3-0.5/24) shows the elapsed time. Is it possible to customize the way I enter the date like the...
  5. I

    only one code executes after i merged two codes together

    Morning, I have merged two codes together but the seocnd part of the code does not execute / run I press my PRINT 1 INVOICE BUTTON on my worksheet. The invoice is then printed. I see the msgbox CLEAR INVOICE AFTER PRINTING. I press the OK button but after the msgbox is closed then this is...
  6. L

    list of properties and methods after type . after the object name

    Hi I tried to google this but do not know the name of the list. When I type Workbooks(1) for example and then the dot, I will get a list of all methods etc. What this list called? How I can control it. I mean if it was not there, can I go to settings and enable it? Thank you very much.
  7. Z

    Spaces in a searchable dropdown

    I have made a drop down list that is searchable using formulas and it works. However if i type in 2x4 it gives me certain items. If i type in 2 x 4 with spaces it gives me different items. =IFERROR(VLOOKUP(ROWS($I$2:I2),$C$2:$D$3799,2,0),"") this one looks to see if there is text from what is...
  8. D

    advanced filtering vba picks up wild cards?

    so i have in column A...booking point...and under that...x376x, x324x.... in column B, i have product type....under that, TR Swap for whatever reason, when i pull this data in using a vba macro based on the criteria above, it's also pulling in booking point "x324xVAL," but i dont want that...i...
  9. T

    Macro to adjust a textbox to the size of the text

    Hi Everyone, I've been playing around with activex text boxes and have found I can adjust the height as I type. so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in I have this bit of code that will resize the text box so I...
  10. S

    Error: We Cannot Convert a value of Type Function to Type list

    I have been trying to create a function to calculate the number of working days (including holidays). I found instructions on how to create fnNetworkdays but I am getting the following error when I try to use it in a query: Expression.Error: We cannot convert a value of type Function to type...
  11. N

    Time conversion help

    Hi, Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful. I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2. What I need now is...
  12. D

    Make text box invisible when print to pdf

    I have a textbox that has the text "Please type notes here" and a button that prints to pdf. If no notes are written in the textbox, a blank text box with the text "Please type notes here" will still appear when I print to pdf. How do I make the text box invisible if it contains the text "Please...
  13. StuLux

    VBA Autofilter for 3 or more criteria

    I've read several posts about how to use autofilter with more than 2 criteria and the answer seems to be to use an array - I am trying the following but get a Type Mismatch error on the Criteria 2 line? Criteria1 = "*Meeting 1*" Criteria2 = Array("<>*at their Stand*", "<>*Table...
  14. B

    block user from refreshing pivit tabel

    hi is there a way through an excel vba to disable the refresh button in excel for a power pivot table or any type of refresh ? i don't want to protect the sheet i just want to disable refreshing it (with a password)
  15. T

    Type Mismatch Using SumProduct

    Hello, Let's say rng1 is some range like A1:A10, and rng2 is some range like B1:B10. I am trying to do the Application.WorksheetFunction.Sumproduct and it is giving me a type mismatch. I have: Application.WorksheetFunction.SumProduct(--(rng1 > 0), rng1, rng2) I only want to sumproduct...
  16. M

    Count the number of workers by 15 minute interval

    H All, I’ve broken my brain on excel and need assistance….. I’ve built a doc to help me calculate the number of staff working by 15 minute interval per day of the week. I have around 50 staff but they all work different days & hours in the day. I seem to be having issues at certain times of...
  17. BlakeSkate

    String Array Error

    Sub test() Dim textVAR(0 To 5) As String Dim i as Long textVAR(0) = "Do" textVAR(1) = "Re" textVAR(2) = "Me" textVAR(3) = "Fa" textVAR(4) = "So" textVAR(5) = "La" For i = LBound(textVAR) To UBound(textVAR) If textVAR = "Do" Then msgbox textVAR Else msgbox "Nope" End If next i End Sub if i...
  18. bfreescott

    Offset

    anyone have an experience with offset returning a wrong data type error when increasing the height above 1? =OFFSET(A1,0,0,1,1) works just fine. =OFFSET(A1,0,0,2,1) produces wrong data type. Starting with a different reference doesn't seem to make a difference.
  19. T

    Multiple MATCH with WORKDAY

    Here is my data: Col A Col B Col D Col E <tbody> 01/01/2010 a 31/12/2009 a 02/01/2010 b 01/01/2010 b 03/01/2010 c 02/01/2010 c 04/01/2010 d 03/01/2010 d </tbody> In cell G1, I type: =MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4,3)),0)...
  20. J

    Counting a Time Range with COUNTIFS or SUMIFS

    Good Morning I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet. Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top