(Solved) – VBA code for inserting table with some drop down values in excel


I am trying to write a VBA code for inserting a table with some dropdown values for Heading and also for Inline elements. But I’m confused about the data validation part.
I want to insert a table on ‘Insert module’ button click. that table should have suggestions for the heading and each row as well. Heading suggestions are different from row suggestions.

Here is my code for inserting the table and its working fine.

Dim objTable As ListObject
Set objTable = ActiveSheet.ListObjects.Add(xlSrcRange, Selection, , xlYes)

Leave a Reply

Your email address will not be published. Required fields are marked *