Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    3
    Views
    180

    Re: Annoying Excel 2019 Habit

    Here is a picture of the situation.
    185206
    If I'm editing and I click the 'View Microsoft Excel' button, it takes me to the Excel window, but if I move my cursor down from anywhere above the top of...
  2. Replies
    3
    Views
    180

    Annoying Excel 2019 Habit

    In Excel 2019 with both the Excel and VBA window open, if I pass my cursor over the VBA window on my way to a worksheet, I'm annoyingly taken to VBA.

    In Excel 2010 that didn't happen. Is there...
  3. MsOf10 Re: Speed up the copying of data from one worksheet to another

    Self-solved.
  4. MsOf10 [RESOLVED] Speed up the copying of data from one worksheet to another

    In Excel have this code which copies numbers from one worksheet to another. The destination column to which the data is copied depends on the value of the number. For example 1s are copied to column...
  5. Replies
    6
    Views
    292

    Re: Counting colors

    I apologize for wasting your time. I've just discovered that most of the 20 seconds is due to the time it takes to calculate formulas similar to the following (where "Z" varies from "Z" to "AI") in...
  6. Replies
    6
    Views
    292

    Re: Counting colors

    Thanks Zvoni, but I believe the colors being counted in that article are cell.Interior colors whereas my colors are the result of conditional formatting rules and for those you need to refer to...
  7. Replies
    6
    Views
    292

    Counting colors

    I have a worksheet that has over 20,000 rows, and in those rows conditional formatting is used to color the cells nine different colors depending on the cell's numerical values. For example,

    ...
  8. Replies
    3
    Views
    268

    Re: Excel Userform Grid Control

    "However, if I need a grid in Excel, I like to keep it simple. Since I am using Excel, I just create a sheet tab that has what I need. No need to re-invent the wheel (or grid)."

    I never thought of...
  9. Replies
    3
    Views
    268

    Re: Excel Userform Grid Control

    I realize now that I can create a "grid" out of an array of textboxes. Is there any built-in control I can use?
  10. Replies
    3
    Views
    268

    [RESOLVED] Excel Userform Grid Control

    I'm using Excel 2016 and I would like to add a grid or grid-like control in a userform. In my userform's toolbox, additional controls, I don't see MSHFlexgrid or MSFlexgrid or anything that I...
  11. MsOf10 Re: [RESOLVED] Pressing Enter in userform listbox

    The entries in the listbox are unique, but thanks again for pointing out that I should exit the loop.
  12. MsOf10 Re: Pressing Enter in userform listbox

    Wow, am I embarrassed. The KeyDown event was in the wrong place. It should have been in the code for the 'Search' textbox on the userform that I want to use to locate entries in a listbox with many...
  13. MsOf10 Re: Pressing Enter in userform listbox

    In order for a message box to do anything for me on the first press of the Return key, the event would have to fire, and it doesn't. I proved that by placing a breakpoint on the sub's declaration...
  14. MsOf10 [RESOLVED] Pressing Enter in userform listbox

    I have this code in my userform's listbox.


    Private Sub lstFrom_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

    Dim lngEntry As Long
    Dim bMatched As Boolean

    If...
  15. Replies
    6
    Views
    380

    MsOf10 Re: Server isn't responding

    I found the problem. I download the workbook into a workbook object and I wasn't closing that object. After I added code to close it when I was done with it, the server for some reason I don't...
  16. Replies
    6
    Views
    380

    MsOf10 Re: Server isn't responding

    It is on a Mac but on that Mac I have a Windows 10 Virtual Machine in which I use Excel.

    There is no problem the first time I download a workbook from the server but if I do it a second time in...
  17. Replies
    6
    Views
    380

    MsOf10 Re: Server isn't responding

    Thanks, but I'm looking for code that I can add to the same procedure (a macro) that downloads the workbook.
  18. Replies
    6
    Views
    380

    MsOf10 [RESOLVED] Server isn't responding

    In Excel 2010 I have a procedure where the user enters the name of the workbook (e.g. MyWorkbook.xlsx) in a string variable named strLink and I append the workbook name to a hard-coded web location....
  19. Replies
    0
    Views
    291

    [RESOLVED] Formula Needed

    Self-Solved
  20. Replies
    3
    Views
    267

    Re: Conditional formatting problem

    Thanks, but for readability purposes I'd prefer a formula that refers to the specific values.
  21. Replies
    3
    Views
    267

    Conditional formatting problem

    I'd like to have a conditional formatting rule apply to cells with any of these values 10, 20, 30, 40, 50, 60, 70 or 80. I know that if there was just one value (for example 10) that I could use...
  22. Re: [RESOLVED] Help me find an undefined variable

    Opening the workbook with Repair fixed the problem.
  23. [RESOLVED] Help me find an undefined variable

    I have a lengthy macro in a module that has Option Explicit. It compiles with no problems and runs without error for me in Excel 2019, however someone else running it in an unknown version of Excel...
  24. Re: Display contents of Word file in OLE container

    Windows XP on the same computer. My Windows XP is actually a virtual machine on my iMac but I've never seen that make any difference.
  25. Re: Display contents of Word file in OLE container

    When I added the OLE control to my form it asked what the Class was and I said Microsoft Word and it shows Word.Document.12 in the control's properties. However when I Debug.Print the class it says...
  26. Display contents of Word file in OLE container

    I have the following code. When it runs it only displays the name of the file in my form's OLE container. How do I display the document's content?

    Private Sub Command1_Click()
    OLE1.DisplayType =...
  27. Replies
    0
    Views
    371

    [RESOLVED] Fastest Transformation

    In the attached workbook I'd like the fastest code that will create Sheet2 as a transformation of Sheet1, retaining Sheet2's headings. Sheet2 should have the same colors as Sheet1. I have code that...
  28. Replies
    2
    Views
    543

    Re: Named Range Formula Problem

    Thanks!
  29. Replies
    2
    Views
    543

    [RESOLVED] Named Range Formula Problem

    Column J in my workbook has three headings and a variable number of rows starting in row 4. The following flexible formula works just fine (it refers properly to all the data in J starting at row 4)...
  30. Replies
    4
    Views
    456

    Re: COUNTIF woes

    Thanks, that was it. I'm using VBA to do this and apparently during early testing I accidentally wrote data way down in row 7000 that wasn't cleared.
  31. Replies
    4
    Views
    456

    [RESOLVED] COUNTIF woes

    I have a column that has values like the following and I wanted to count how many times 60 occurs. Using COUNTIF I expected the answer to be 1, but the formula =COUNTIF(A:A,60) returns 2 because 60...
  32. Replies
    2
    Views
    462

    Re: Need Excel Formula Help

    Thanks!
  33. Replies
    2
    Views
    462

    [RESOLVED] Need Excel Formula Help

    The formula in column F is =IF($E3<>"","",SUM($C3:$D3)). How can I change it so that the 0.00 values in column F are eliminated leaving F6 as is.
    184526
  34. Re: Formula - Keep destination formatting

    You are correct. Thanks.
  35. [RESOLVED] Formula - Keep destination formatting

    I have this formula in Sheet1
    ='Sheet2'!C8

    The source cell has no fill color but the destination cell has a fill color. How do I modify that formula so that the destination cell's fill color is...
  36. Replies
    4
    Views
    435

    Re: Scraping a lotto site

    Thanks.
  37. Replies
    4
    Views
    435

    Re: Scraping a lotto site

    "...found on this site..."
  38. Replies
    4
    Views
    435

    Scraping a lotto site

    Someone has asked me to get the lotto winning number results from a website. I've never done anything like that before and so after some research I have this so far. What table name do I use and how...
  39. Re: Show available workbooks in date descending order

    That's correct, I'm not.

    I'm using Excel 2019's Open dialog.
    184406
  40. Re: Show available workbooks in date descending order

    Thanks, but Windows Explorer (in my case actually File Explorer) shows newest first.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width