Jump to content
Sign in to follow this  
rharwood

_excel question

Recommended Posts

rharwood

In my script I am updating a excel shreadsheet based on data I receive from a serial port, This part works fine, My question is can I change focus to the cell that I am updating so that the user can see the updating on the screen???

Share this post


Link to post
Share on other sites
picaxe

$oExcel.ActiveSheet.Range("A15").Select ; select or set focus to cell A15

Share this post


Link to post
Share on other sites
rharwood

$oExcel.ActiveSheet.Range("A15").Select ; select or set focus to cell A15

Thank picaxe worked like a charm , where are these calls documented so I can look them up

Share this post


Link to post
Share on other sites
picaxe

Thank picaxe worked like a charm , where are these calls documented so I can look them up

You are welcome, I use the Excel vba editor help file and the object browser. Viewing code generated by the Excel macro recorder is also helps.

Share this post


Link to post
Share on other sites
rharwood

You are welcome, I use the Excel vba editor help file and the object browser. Viewing code generated by the Excel macro recorder is also helps.

I guess I'll have to find my disk , I dont have the help fill installed

Share this post


Link to post
Share on other sites
Juvigy

You can also check the excel VBA reference on the msdn.microsoft.com.

Everything is there.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×