ShowDataForm

[gibbo1715]

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]

Sorry but the answer is no.

[gibbo1715]

Thats what I expected but thanks anyway, was curious

Gibbo

[Marcster]

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]

So it is possible to make a dataform then, thanks gives me some ideas

[Norie]

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]

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]

Just added an example DataForm here.

http://www.excel-it.com/workbookdown...kdownloads.htm

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

[gibbo1715]

That answers my question really,

cheers

gibbo