convert 123 macro to visual basic in excel 2000

J

Joe Silvers

Here is an example of a short lotus 123 macro that I use
to enter data into a formula sheet. I need to convert
this to a excel 2000 macro. I would like for it to
function exactly the same way it did in lotus 123.

{goto}E3~
'{?}{D}'{?}{D}'{?}~
{GOTO}C8~'{?}~
{GOTO}A1~{GOTO}D10~
{?}{D 2}{?}{D}{?}
{D}{?}{D}{?}{D}{?}
{D}{?}{D}{?}{D 4}"{?}~
{IF $E$98<D10}{HOME}{GOTO}D10~{BEEP}
{?}~{HOME}{GOTO}A25~{CALC}{?}

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lotus macro i need to convert to Excel 4
converting lotus macro 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Converting from 123 to Excel 7
Converting macros from Excel 2003 to Excel 2010 - Client Access dialog 3
Help with function, if possible 8
converting formula from lotus.123 to excel 2
Converting Lotus function to Excel 1

Top