Access or Macro
 

Good day
Thanks for reading.
I need to create a user interface that will allow the user to input some
values and then the program/macro will use this information to look across
some excel sheets.
Once it finds a match it needs to gather some information contained in their
cells, do some logical or simple math calculations to output a result onto
the user interface.
Which one is better suited to do this kind of job?

I appreciate your input.
Best Regards

Access or Macro
 

I would use a user form.
Look at vba editor (alt f11) You can create a user form here and program any
elements you include within this user form using VBA (macro) to do whatever
you need.

"dab" wrote:

Good day
Thanks for reading.
I need to create a user interface that will allow the user to input some
values and then the program/macro will use this information to look across
some excel sheets.
Once it finds a match it needs to gather some information contained in their
cells, do some logical or simple math calculations to output a result onto
the user interface.
Which one is better suited to do this kind of job?

I appreciate your input.
Best Regards

Access or Macro
 

Hello
Thanks for the help.
I will give it a try.
Regards


"Atishoo" wrote:

I would use a user form.
Look at vba editor (alt f11) You can create a user form here and program any
elements you include within this user form using VBA (macro) to do whatever
you need.

"dab" wrote:

Good day
Thanks for reading.
I need to create a user interface that will allow the user to input some
values and then the program/macro will use this information to look across
some excel sheets.
Once it finds a match it needs to gather some information contained in their
cells, do some logical or simple math calculations to output a result onto
the user interface.
Which one is better suited to do this kind of job?

I appreciate your input.
Best Regards