BubnaShreya-0514 avatar image
0 Votes"
BubnaShreya-0514 asked ·

VBA to format data type of table with Parameters

Hello, I have a number of tables in my excel workbook, whose column data types I hope to format with VBA. I have setup a parameters sheet, with a table as follows TableABC in the attachment.

I hope to write VBA which will take the column headers and format them to the type specified in the next column for my tableABC. I cannot hardcode the column headers in VBA as they might change so I want to do this with a parameter table.

Kindly help with this.

Thank you

formatabc.png (2.7 KiB)
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Lz-3068 Thank you so much for your help with the previous questions! If possible kindly help with this similar one.

Thanks again!

0 Votes 0 ·

0 Answers