Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    2
    Views
    271

    Re: Permutations?

    Thanks, but I found my own relatively simple solution. strRangeText is the comma delimited string and strHits is an array.



    Dim intStart As Integer
    Dim intNext As...
  2. Replies
    2
    Views
    271

    [RESOLVED] Permutations?

    I get confused between permutations and combinations, but anyhow I have ten columns, some of which may be blank while the rest contain one or two-digit numbers. Let's assume that the first row...
  3. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    Yes it does work. Sometimes I amazed how dumb I can be.
  4. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    I bet it only works if the workbook only has one userform, or, if there's more than one userform, it shows the one that Excel determines is the first one.
  5. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    Thanks. It sort of works. In my workbook I have several userforms and in the DisplayUserForm sub I changed date_Form to the name of the userform I wanted to position and I changed Activecell to the...
  6. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    Thanks but I tried that already and couldn't get the userform to even come close to where I wanted it. Here is the code I used

    Sub Marty()
    Dim PS As Positions
    Range("H10").Select
    ...
  7. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    Thanks, Chip has some remarkable code on his site but I don't see how the link helps me to align the top of my userform with the top of a cell. In my question I simplified it a bit in that I also...
  8. Replies
    11
    Views
    526

    Re: PointsToScreenPixelsX

    Thanks but I've seen most of them and either they don't work or they don't apply.
  9. Replies
    11
    Views
    526

    [RESOLVED] PointsToScreenPixelsX

    I assume that PointsToScreenPixelsX comes into play if I want to align the top of my userform with the top of a cell, but what is the statement that does that? Would it be affected by either the...
  10. Re: Count of unique values in a collection

    Found an easy solution using a worksheet, =Unique and =CountA. No collection or Dictionary needed.
  11. Re: Count of unique values in a collection

    Can you supply sample code? I haven't had any experience with dictionaries.
  12. [RESOLVED] Count of unique values in a collection

    I have a sorted collection of 4-digit numbers and many of the numbers are duplicated. I'm looking for a quick way to get a count of each unique value. For example if 1234 occurs 3 times in the...
  13. Replies
    12
    Views
    572

    Re: Converting VB6 add-in

    An article I read suggested that the dll could be saved as an exe which I've done. How to I register it in 64 bit?
  14. Replies
    12
    Views
    572

    Re: Converting VB6 add-in

    yereverluvinuncleber. Have you ever used TwinBasic? I emailed them describing what I want to do.
  15. Replies
    12
    Views
    572

    Re: Converting VB6 add-in

    Thanks Dan. I've actually implemented a replacement listview control in 64 bit Excel. Have you ever concerted a VB6 dll to 64 bit?
  16. Replies
    12
    Views
    572

    Re: Converting VB6 add-in

    Yes VB6. I initially wrote it for VB6 which has a UI similar to Excel and with a few simple changes I made one for 32 bit Excel since (I think) at that time Excel 64 bit didn't exist.
  17. Replies
    12
    Views
    572

    Converting VB6 add-in

    I have the code for a VB6 add-in that I wrote many years ago. It was (of course) written in a 32-bit environment and it added certain useful functions to the Excel toolbar. Those functions brought up...
  18. Replies
    3
    Views
    435

    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...
  19. Replies
    3
    Views
    435

    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...
  20. MsOf10 Re: Speed up the copying of data from one worksheet to another

    Self-solved.
  21. 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...
  22. Replies
    6
    Views
    518

    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...
  23. Replies
    6
    Views
    518

    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...
  24. Replies
    6
    Views
    518

    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,

    ...
  25. Replies
    3
    Views
    477

    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...
  26. Replies
    3
    Views
    477

    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?
  27. Replies
    3
    Views
    477

    [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...
  28. 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.
  29. 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...
  30. 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...
  31. 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...
  32. Replies
    6
    Views
    569

    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...
  33. Replies
    6
    Views
    569

    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...
  34. Replies
    6
    Views
    569

    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.
  35. Replies
    6
    Views
    569

    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....
  36. Replies
    0
    Views
    415

    [RESOLVED] Formula Needed

    Self-Solved
  37. Replies
    3
    Views
    375

    Re: Conditional formatting problem

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

    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...
  39. Re: [RESOLVED] Help me find an undefined variable

    Opening the workbook with Repair fixed the problem.
  40. [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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width