1. M

    determine how many elements an array will have

    Hi newbie needing to know how to declare an array where we don't know how many elements due to always increasing I have a list in A1 to A10 and need to use lastrow to declare array also would like to display msgbox after the loop to give a list of all items (don't know if this would be join or...
  2. Roderick_E

    Excel as Interface

    Ok so I'm about to move into the wonderful world of Access DB, but I want to continue to use my Excel skills. I intend to create a workbook that will pull just certain elements from the Access DB. I don't need to download the entire DB each time do I?
  3. M

    VBA HTML - how do I access elements of Google Chrome

    Hi, I am familiar with accessing the elements of a webpage using the CreateObject("InternetExplorer.Application"). I was wondering if there is a similar way to access the elements of Google Chrome and Firefox Mozilla ? Thanks.
  4. diddi

    Getting elements of a Type declaration

    hi I was wondering if it is possible to determine the elements within a declared Type. so as an example, I have a variable "Invoice" as declared Type Invoice Job As Integer CustomerRef As String * 20 Amount As Single End Type Dim MyInvoice as Invoice is there some way of...
  5. B

    VBA Get Elements About

    Hello, I want to get elements image src links from web to my excel sheet, For example link: https://www.ebay.com/rpp/sales-events-en/GEO-Favorite-Fashion-FS-ROW/for-her Can I get this link ? https://i.ebayimg.com/images/g/5zwAAOSw3ydVwx4e/s-l400/p.jpg http://prntscr.com/i24m4t Thx for helping.
  6. A

    Font Colour in Comment

    I believe this changed in Excel 2007 (from 2003) where this worked .Characters(1, l).Font.Color = RGB(153, 51, 0) I thought it was now .Font.ColorIndex but that didn't work either. Also, is there any way to debug.print all elements before ".Characters" to check what they are? Thanks.
  7. K

    Mapping data using formulas.

    I have 2 sets of data in 4 columns. In DB1 is the main database. DB2 is the information extracted from a vendor application. DB1-SystemName DB1-ipaddress DB2-SystemName DB2-ipaddress What I am trying to achieve using excel formulas is to map the data elements to DB1 elements. The...
  8. R

    All combinations of k from n from different groups, whose sum is in a specific range

    I'll make an example. I have three groups: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...
  9. T

    Rename grouped control elements

    I’m building a excel sheet where i’m using a template sheet that I copy to a new sheet whenever I need it. This works fine but I have one problem as I have created a group of control elements in order for me to maintain their relative location to each other. But when I copy the control it...
  10. V

    Macro(s) / Excel formula(s) to automatically extract multiple elements from a complex string

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello! As I got no answer yet and need it as fast as possible, I return to my message posted before on MrExcel forum. It’s focused on extracting some specific elements...
  11. V

    Macro(s) / Excel formula(s) to automatically extract specific elements from a string

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good evening! I posted yesterday a message on MrExcel forum, focused on extracting some specific elements (marked in the attached document by red colour) in two other cells...
  12. M

    A way of retrieving the number of elements in a VBA Array

    Hi Guys, I have a small project of developing some VBA Code to simplify a spreadsheet for specifiing IO for Control Systems. In my VBA Code, I have utilised an Array in order to work with the specified spreadsheet range as CountIF will not do what I want it to do (Long Story). Anyway, I would...
  13. I

    2 question: Concatination of Array and access to arrays element in cell

    Hi everyone! Here is a task about array, I can't resolve. I have the array like {text1,text2,text3} and I want to joint elements of the array in string like "text1text2text3" I try to use array formulas, but it doesn' work :( Why Mcrosoft haven't realize sum-like formula for text :confused...
  14. Y

    Website element value copied to Excel cell from Chrome Browser

    Let me first say that this process does work when I am going from Excel (2007/2010) to IE 7/8, although it is slow it does the job. Essentially what it does currently is that it takes the address and copies and pastes it into the USPS website to check and see if there is a valid zipcode and...
  15. J

    Close workbooks saved as elements in an array

    Hi all, I have an array of data type Variant, who's elements are workbooks opened by a user. The array size is static, which for now isn't a concern but I can't work out how to close the workbooks in the array via a loop and the usual vba code of Workbooks("file").Close Code I have that...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...