PDA

View Full Version : [SOLVED] ShowDataForm



gibbo1715
09-04-2005, 06:04 AM
I know i can use ActiveSheet.ShowDataForm to get an inputform to edit a list on my spreadsheet

My question is is this form in anyway editable?

Cheers

Gibbo

Norie
09-04-2005, 08:18 AM
Sorry but the answer is no.

gibbo1715
09-04-2005, 08:20 AM
Thats what I expected but thanks anyway, was curious

Gibbo

Marcster
09-05-2005, 07:48 AM
John Walkenbach has written his own version of the built-in Excel data form here, which you can download:

http://www.j-walk.com/ss/dataform/
Marcster.

gibbo1715
09-05-2005, 09:31 AM
So it is possible to make a dataform then, thanks gives me some ideas

Norie
09-05-2005, 09:56 AM
So it is possible to make a dataform then, thanks gives me some ideas
Yes it is possible, but you can't customize the existing one.

gibbo1715
09-05-2005, 10:15 AM
So I assume I can just create a userform to navigate my data etc as I do normally then add a menu item and save it as an addin, or is there a simpler way of creating a data form?

royUK
09-05-2005, 11:01 AM
Just added an example DataForm here.

http://www.excel-it.com/workbookdownloads/workbookdownloads.htm

You can add, delete amend items. Also, Find specific items - listing multiple instances

gibbo1715
09-05-2005, 01:52 PM
That answers my question really,

cheers

gibbo