Excel VBA single cell referencing

Forum for discussing PicoLog
Post Reply

Excel VBA single cell referencing

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

User avatar
Site Admin
Site Admin
Posts: 598
Joined: Wed May 07, 2003 9:45 am

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


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,

Mark Spencer


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

Thanks markspencer with your help i have got that workin.

Cheers :D

Post Reply