Search:

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?

yereverluvinuncleber. Have you ever used TwinBasic? I emailed them describing what I want to do.

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

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.

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...

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...

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...

Self-solved.

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...

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...

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...

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,

...

"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...

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

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...

The entries in the listbox are unique, but thanks again for pointing out that I should exit the loop.

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...

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...

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...

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...

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...

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

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....

Self-Solved

Thanks, but for readability purposes I'd prefer a formula that refers to the specific values.

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...

Opening the workbook with Repair fixed the problem.

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...

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.

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...

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 =...

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...

Thanks!

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)...

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.

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...

Thanks!

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

You are correct. Thanks.

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...