Create Own User form

[forrestgump]

Hi,

I want to create my own user form like the one in the data tab. I want to be able to see the detail in the cell and have the opportunity to overwrite. Does any one know where I can download an example form where by I can amend the VBA code?

Regards,

James

[Bob Phillips]

So what is wrong with datatab?

[Paul_Hossler]

Dumb question -- in 2003 there used to be a generic userform that would do some data maintenance on a WS list, but I can't find it in 2010.

The OP's post reminded me about it, an I have a use for it, but now I can't find the darn thing :banghead:

Paul

[Bob Phillips]

Paul,

Try Alt-D-O

[Paul_Hossler]

1. Thanks

2. I love the macro recorder. It's smarter that I am


Option Explicit
Sub Macro1()
'
' Macro1 Macro
'
'
Range("A1:E11").Select
ActiveSheet.ShowDataForm
End Sub


Paul

[Aflatoon]

You may also add the 'Form...' button to the QAT or Ribbon.