Excel mobile data entry form

[DanielGreenwood]

Hi

I'm trying to create a data entry spreadsheet for a windows 6.5 device (HTC HD2) running Office Mobile 6.1.

The problem I'm having is that none of the validation/vba features are available when opened on the device. Does anyone have any ideas how to either to get these to work or what approach you might take if this is a no go?

Main requirement is to have drop down boxes with prefilled choices against around 40 questions.

Really appreciate any help you can give.

Thanks

Dan

 

[SkipVought]

Maybe forum1466


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mintjulep]

Except that fora gets almost zero traffic.

From a few minutes of Googling it seems that Office Mobile does not support VBA and the Excel for mobile is a sub-set of desktop excel functionality.

So building your own app is one way to go.

http://msdn.microsoft.com/en-us/library/bb158522.aspx

I suspect that the "offical" MS preferred solution is InfoPath.