Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access data form through command button
Hi: Can anyone please let me know if its possible to have a command button cause the data form to appear? Thank you in advance for your help. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access data form through command button
Try this
Range("A1").Select ActiveSheet.ShowDataForm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "aet-inc" wrote in message ... Hi: Can anyone please let me know if its possible to have a command button cause the data form to appear? Thank you in advance for your help. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access data form through command button
Private Sub Commandbutton1_Click()
me.ShowDataForm End Sub If you data isn't in the first two rows (for example the top left cell of the data was D20 and the data table was offset by at least one blank row/column all around) Private Sub Commandbutton1_Click() me.Range("D20").CurrentRegion.Name = "Database" me.ShowDataForm End Sub -- Regards, Tom Ogilvy "aet-inc" wrote in message ... Hi: Can anyone please let me know if its possible to have a command button cause the data form to appear? Thank you in advance for your help. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro attached to command button - VBA form | Excel Discussion (Misc queries) | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Command Button on User form for Printing | Excel Discussion (Misc queries) | |||
Command button on data-entry form | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming |