D
DJ
Is possible to create macro in excel without using VB?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
You mean as in "record" a Macro? Have you looked at what's available to
you?
you?
H
Harlan Grove
DJ wrote...
If you're thinking of Access macros, which aren't VBA, no, Excel
provides nothing comparable. You could create XLM macros in macro
sheets, but you'd be better off using VBA. The macro recorder will
record most actions as VBA code. Have you tried it?
On a different tack, is the issue your macro security settings?
Is possible to create macro in excel without using VB?
If you're thinking of Access macros, which aren't VBA, no, Excel
provides nothing comparable. You could create XLM macros in macro
sheets, but you'd be better off using VBA. The macro recorder will
record most actions as VBA code. Have you tried it?
On a different tack, is the issue your macro security settings?
D
DJ
No, I have one big excel file which I add a bunch of records to it. I want to
create a formula and everytime I added records, it would be able to do the
math for me.
create a formula and everytime I added records, it would be able to do the
math for me.
D
DJ
No, I have very little (or no) knowledge VBA. Thanks anyway.
B
Bob I
Please see Tools, Options, Calculation for the settings.