Excel VBA single cell referencing

Forum for discussing PicoLog
Post Reply
FAM

Excel VBA single cell referencing

Post by FAM »

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
markspencer
Site Admin
Site Admin
Posts: 598
Joined: Wed May 07, 2003 9:45 am

Post by markspencer »

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,
Regards,

Mark Spencer

FAM

Post by FAM »

Thanks markspencer with your help i have got that workin.

Cheers :D

Post Reply