refresh items on form in excel
Hello,
I need some code of refreshing items on form which is shoved a front of excel sheet.
These items are reading data from range of sheet.
For example form is reading first column and I would like to see on form in one item context of each range from first column.
Thank You
:blush:
Radovan Zigraj
Re: refresh items on form in excel
What code do you have at the moment?
You may need a couple of variables: Workbook, worksheet, range
Then you need to read in the range values by looping through the specified range. For this, read up on Range.Cells.
:wave: