I am putting a excel table in a userform so that I can color code some information in it. The data in the table is going to be dynamic based on the value of a combobox.
THe problem that I am running into is that I do not want to run a nested loop to clear the data from the table.
Is there an easier way to "clear" the table without having to run the code above which adds a slight delay to the data being updated.
THe problem that I am running into is that I do not want to run a nested loop to clear the data from the table.
Code:
for i=1to30
for j=1to 15
Me.records.Cells(i, j) = ""
Next J
Next iIs there an easier way to "clear" the table without having to run the code above which adds a slight delay to the data being updated.
