Solved
July 25, 2009
vba userforms carriage return behavior
In a textbox of a userform in VBA, I would like to enable the feature where the user can add a new line in…
thumb_up 18
trending_up 7
excel-vba
136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
July 24, 2009
Data extraction with Excel
I monthly receive 100+ excel spreadsheet from wich i take a fixed range and paste in other spreadsheet to make a report. Im trying…
thumb_up 6
trending_up 5
Solved
June 2, 2009
How to get a DateDiff-Value in milliseconds in VBA (Excel)?
I need to calculate the difference between two timestamps in milliseconds. Unfortunately, the DateDiff-function of VBA does not offer this precision. Are there any…
thumb_up 31
trending_up 14
Solved
May 27, 2009
How can I run SQL statements on a named range within an excel sheet?
All I am trying to do is take a standard range on an excel sheet (i.e. a named range, or even A1:F100), and run…
thumb_up 12
trending_up 14
Solved
May 12, 2009
Hiding an Excel worksheet with VBA
I have an Excel spreadsheet with three sheets. One of the sheets contains formulas for one of the other sheets. Is there is a…
thumb_up 33
trending_up 19
Solved
April 30, 2009
Excel automation – Select all active cells
I have an app where I put a lot of data into an Excel Worksheet. Once I'm done, I would like to select all…
thumb_up 12
trending_up 2
Solved
March 26, 2009
How to “flatten” or “collapse” a 2D Excel table into 1D?
I have a two dimensional table with countries and years in Excel. eg. 1961 1962 1963 1964 USA a x g y France u…
thumb_up 27
trending_up 24
Solved
February 6, 2009
Return background color of selected cell
I have a spreadsheet which cells in are colored meaningfully. Does any body know how i can return the background color value of a…
thumb_up 12
trending_up 11
Solved
January 13, 2009
Can a VBA function in Excel return a range?
I seem to be getting a type mismatch error when trying to do something like this: In new workbook: A1 B1 5 4 Function…
thumb_up 36
trending_up 15
Solved
December 18, 2008
Setting a font color in VBA
I want to set the font color of a cell to a specific RGB value. If I use ActiveCell.Color = RGB(255,255,0) I do get…
thumb_up 7
trending_up 6