Help creating an excel data form!

Dishboy09

New Member
Joined
Jun 11, 2017
Messages
24
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


1575567317911.png
 

Attachments

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
Not if you want a userform.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
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.
 

Forum statistics

Threads
1,082,588
Messages
5,366,490
Members
400,895
Latest member
shumcal

Some videos you may like

This Week's Hot Topics

Top