Solved
September 26, 2012
Test if range exists in VBA
I have a dynamically defined named range in my excel ss that grabs data out of a table based on a start date and…
thumb_up 14
trending_up 5
VBA Core
<p>General-purpose VBA techniques spanning the Office suite.</p>
Solved
September 7, 2012
VBA code to set date format for a specific column as “yyyy-mm-dd”
I have a macro which I specify the date (in mm/dd/yyyy) in a textbox and I want to set this value for column A…
thumb_up 18
trending_up 8
Solved
July 26, 2012
How to highlight selected text within excel
I would like to write a VBA function to highlight specific text within an excel cell. Is this possible? I've been googling but it's…
thumb_up 10
trending_up 2
Solved
July 20, 2012
MS Access send email (not from outlook or user’s email)
I know this question has been asked a few times in various context, but I have not found a clear answer. I have email…
thumb_up 11
trending_up 7
Solved
June 18, 2012
Difference in type between using and not using Set keyword
I just solved a problem I was having putting the "Set" keyword in a definition line but what I would like to know is…
thumb_up 14
trending_up 5
Solved
May 30, 2012
Copy Elements From One Page To Another in Multipage with VBA in Excel
I have a multipage in a userform. During run-time, the user can choose to add x number of pages at any time. The elements…
thumb_up 6
trending_up 5
Solved
May 13, 2012
Remove whitespace in VBA excel
I have some code for move text from cell to cell Dim startIndex As Integer Dim toIndex As Integer Dim f As String Dim…
thumb_up 11
trending_up 1
Solved
April 24, 2012
excel vba: make part of string bold
I have excel cells which contain entries like this: name/A/date name/B/date name/C/date Cell content is displayed on multiple lines in the same cell. I…
thumb_up 7
trending_up 4
Solved
April 19, 2012
Run Excel Macro from Outside Excel Using VBScript From Command Line
I'm trying to run an Excel macro from outside of the Excel file. I'm currently using a ".vbs" file run from the command line,…
thumb_up 14
trending_up 17
Solved
April 12, 2012
Automatically creating hyperlink to another sheet by text
I would like to know how to create a hyperlink from one excel sheet to another, automatically through a script, based on equal text…
thumb_up 10
trending_up 4