Excel VBA single cell referencing

FAM · Post by **FAM** » Thu Sep 11, 2003 9:05 am

Currently i control the logging of my ADC16 via Excel VBA and the data channels it records are 1+3, which go down columns A+B, but what i would like to do is to also add some code so as the latest value from each channel is constantly shown in D5 & D6 respectively.
How can this be done

Thanks in advance

markspencer · Post by **markspencer** » Thu Sep 11, 2003 2:48 pm

Hi,

To enter the values into the cell D5 and D6 you will need to put code into the macro similar to this.

Cells(5, "D").Value = Current value
Cells(6, "D").Value = Current value

Where current value is has been set to the last reading. If more information is required on the VBA side then I would recommend getting a book on Visual Basic Applications, unless someone else on the forum can help you further.

Best regards,

FAM · Post by **FAM** » Tue Sep 16, 2003 8:20 am

Thanks markspencer with your help i have got that workin.

Cheers