Excel Howto?
Excel VBA how to?

-Aviral Mittal


-Under Construction....Pls accept Apologies....
1. How to do Data Validation using VBA
Enable Data Validatoin using VBA. Its easy to enable data validation using Excel GUI
But what if it is desired that this should be done using VBA?
First step would be to add Named Lists to Excel Sheet, which will then be used to validate data.

'------------------------
Function copyColValuesSht1ToSht2(ColNo As Long, srcShtName As String, targShetName as String, Optional stRow As Long,
End Sub

Download the WB with the above code:
Book6.xlsm


<- Previous                                                                                            Next ->

Key Words: Excel VBA: Data Validation