Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading data from com port into excel spreadsheet
I'm reading data from a weight scale that's connected to the com port. I
have the code completed already to read this data in a row and then increment the row. The next problem I'm having is I want to send this data to a label to print it and at the same time keep putting the data in the rows for storage. The label has 5 cells that I want to fill with data and each time the data from the com port can be put into these same cells. Can I put data into a cell without selecting it? Thanks for anybody's help on this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading data from com port into excel spreadsheet
Hi Neil,
"Neil K" wrote: [...] each time the data from the com port can be put into these same cells. Can I put data into a cell without selecting it? Yes You can. Try this: Sub FillInCell() Cells(5, 3) = "Hello, World!" End Sub Success! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading data from com port into excel spreadsheet
Hi Evelien,
Thanks for the response. My variable is "RB" for the buffer coming in. Would I just use your code and instead of text, put Cells(5, 3) = RB ?? Thanks Neil "Evelien Snel" <Evelien wrote in message ... Hi Neil, "Neil K" wrote: [...] each time the data from the com port can be put into these same cells. Can I put data into a cell without selecting it? Yes You can. Try this: Sub FillInCell() Cells(5, 3) = "Hello, World!" End Sub Success! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA READING DATA FROM PIVOT TABLE TO SPREADSHEET | Excel Worksheet Functions | |||
sending data to com1 port from excel | Excel Programming | |||
Reading the pin voltage fm RS232 port into excel by using VBA | Excel Programming | |||
need help re send/recieve com port data from excel and auto CR/LF | Excel Programming |