Tagged Questions
8
votes
2answers
2k views
Pop up the Excel Statusbar?
I'm developing an application for excel that takes a long time to run so it would be nice to have a progress bar pop up and give some indication of the progress. I was looking at the Statusbar ...
10
votes
4answers
3k views
Excel: the Incredible Shrinking and Expanding Controls
Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time.
Nothing in the code is instructing this.
Has anybody else ...
4
votes
1answer
592 views
Incorrect value when counting cells in different versions of Excel
I have seen some SO users run into an issue when trying to use some variation of Cells.Count; the VBA code throws an overflow error in some cases.
For reference, see comments on this answer:
I ...
3
votes
2answers
122 views
VBA macro to mass update multiple files in same location
Very new to this so please help. Im trying to mass update files in a static folder location, many files in one folder.
What i want to do is
run VBA macro in Excel 2010 to goto a network location ...
4
votes
2answers
760 views
Substring colouring from Excel VBA: why do some obvious methods not work?
I've been building some interesting visualizations that rely on VBA code's ability to set different colours for substrings in Excel. For a cell containing a string the sytax works like this ...
9
votes
3answers
17k views
VBA error 1004 - select method of range class failed
First time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know so that I can fix it.
So I am basically asking the user for the file directory of the excel ...
2
votes
1answer
67 views
Pivottable woes
It seems like all of the examples from other people are just like what I already have in my code. But in my case, nothing resolves the problem. So here is the complete code along with a break to show ...
1
vote
2answers
80 views
Scripting in Excel — Highlighting like values
I am trying to create a macro that will basically highlight like values in column A the same color and alternate between a blue and white coloring. Therefore, exact values are grouped together by ...
1
vote
1answer
445 views
Execl VBA: Any tips and/or suggestions for migrating from MSSOAPLib to MSXML2?
I am migrating some spreadsheets from Excel 2003/WinXP to Excel 2010/Win7.
Some spreadsheets use the MS SOAP toolkit to retrieve data. MS drops the support of SOAP toolkit in Excel 2010. I am forced ...
1
vote
1answer
270 views
How to edit info in cells displayed via macro code in Excel?
I have a macro so that when you highlight a row on sheet1, the macro takes all the info from this row and displays this by itself on sheet2. If you highlight a different row on sheet1, the info on ...
0
votes
1answer
91 views
how to keep the first cell always active in excel using vba
How to keep the first cell always active when opening the excel sheet.
Can any one guide me to how to this.
This is my
code:
Private Sub Send_Click()
Dim strURL As String
...
6
votes
3answers
38k views
Copy an entire worksheet to a new worksheet in Excel 2010
I have found similar questions that deal with copying an entire worksheet in one workbook and pasting it to another workbook, but I am interested in simply copying an entire worksheet and pasting it ...
2
votes
2answers
419 views
Regex match in VBA (Excel) [closed]
I am trying to write a function for excel 2010 that will take a line of HTML and return the link address ("http://www.google.com" in the example). Every lines follows this exact pattern:
<a ...
1
vote
2answers
53 views
Excel 2010 VBA - Map column data?
I have a sheet like this:
| A | B | C | D | E | F | G | H | ...
---------------------------------
| a | 1 | | b | 2 | | c | 7 |
---------------------------------
| b | 2 | | c | 8 | | b | 4 |
...
6
votes
1answer
6k views
Can I use VBA in Excel 2010 Starter Edition?
I have the MS-Excel 2010 "Starter Edition" - it comes bundled into pre-built PCs.
Does this edition support VBA macros? I cannot tell.
I searched and I am still not clear on this.
