Excel VBA single cell referencing

 
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
Author Message
FAM
Guest
PostPosted: Thu Sep 11, 2003 9:05 am    Post subject: Excel VBA single cell referencing Reply with quote
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 Question

Thanks in advance
Back to top
markspencer
Site Admin
Site Admin


Joined: 07 May 2003
Posts: 610

PostPosted: Thu Sep 11, 2003 2:48 pm    Post subject: Reply with quote
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,
Back to top
FAM
Guest
PostPosted: Tue Sep 16, 2003 8:20 am    Post subject: Reply with quote
Thanks markspencer with your help i have got that workin.

Cheers Very Happy
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pico Technology Forum Index -> PicoLog
All times are GMT
Page 1 of 1

 


Pico Technology topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group