Help creating an excel data form!

[Dishboy09]

I am looking to build an excel data form to be able to gather some data.

A) Type in an address or data for search
B) Information that is saved within the data page and shows up telling you about what you searched for.
--- If the data search brings back no data put "no data found" in the information box.
C) If you information box brings up the "no data found" the add new entry link/box pulls up a separate form to input data to the main data page.

I am wanting this to be accessible from a mobile device, and the data be sent to a separate excel sheet for viewing. I am looking for just the form to pop up when accessing it on the mobile.


THANKS

 

[Fluff]

The mobile version of xl does not support VBA, so you would probably need to create an add-in using javascript.
To find out how to do that, have a look here

Office Add-ins documentation - Office Add-ins

Learn how to build Office Add-ins.

docs.microsoft.com

 

[Dishboy09]

The mobile version of xl does not support VBA, so you would probably need to create an add-in using javascript.
To find out how to do that, have a look here

Office Add-ins documentation - Office Add-ins

Learn how to build Office Add-ins.

docs.microsoft.com

Do you have any other recommendations for how to handle this request?

 

[Fluff]

Not if you want a userform.

 

[Dishboy09]

Not if you want a userform.

I’m up for ideas if something other than a userform would do a similar thing?

 

[Fluff]

If you don't want to use java, then everything would have to be done by formulae and I'm not sure that would be possible.