AutomateNow
Excel tips, tricks and tutorials for the intermediate to advanced user in recording macros, writing scripts in VBA, and creating user-defined functions while optimizing performance.
Thursday, May 10, 2012
VBA Programming in Excel 2010
Are you upgrading to Excel 2010 soon? My suggestion would be to familiarize yourself with all the rich features now! Unlock your full potential with the following release from John Walkenbach available now on Amazon.com:
Friday, February 10, 2012
Saturday, May 7, 2011
Data Validation List based on another data validation list
Have you ever thought how simple life could be if you could make your spreadsheets act more like a form without going through the trouble of creating one? In today's example you can create a list of values in one field where another list is populated based on what the user selects!
Sub list2()
With Cells(1, 2).Validation
.Delete
If Cells(1, 1) = "one" Then
.Add Type:=xlValidateList, Formula1:="A, B, C"
ElseIf Cells(1, 1) = "two" Then
.Add Type:=xlValidateList, Formula1:="D, E, F"
ElseIf Cells(1, 1) = "three" Then
.Add Type:=xlValidateList, Formula1:="G, H, I"
End If
End With
End Sub
The above example will only refresh when the macro is run. If you want this to run as soon as a value is chosen you may want to set this into the worksheet where an event will trigger it to run.
Thursday, March 3, 2011
Unhiding Multiple Worksheets
Most people who use Excel know that you can hide one or more sheets in Excel. Thanks to thesimplemachine.com we now have a short code for unhiding these sheets all at once rather than one at a time. Take a look!
Unhiding Multiple Sheets with VBA
Subscribe to:
Posts (Atom)