View Full Version : Create Own User form
forrestgump
08-19-2011, 01:58 PM
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
08-19-2011, 03:39 PM
So what is wrong with datatab?
Paul_Hossler
08-21-2011, 08:09 AM
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
08-21-2011, 08:13 AM
Paul,
Try Alt-D-O
Paul_Hossler
08-21-2011, 08:29 AM
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
08-22-2011, 01:21 AM
You may also add the 'Form...' button to the QAT or Ribbon.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.