Hi All!
I am trying to dynamically assign column width for each column in a listbox. I am calculating the maximum length of a string in a column and assigning maximum length + 5 as the column width. But when the list box pops up after the code is executed, all the column values still remain...
Hi Everyone,
I was wondering if there is a way in excel-vba to do this.
In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the...