View Full Version : [SOLVED:] Cannot Launch Data Form with Macro
stevewater
02-25-2005, 11:33 AM
I?m trying to get the Xl ?Data Form? to work from a evoked macro, however it always wants to default back to cell (A1), even when my code directs it to (A20)
Range("A20").Select
ActiveSheet.ShowDataForm
mdmackillop
02-25-2005, 11:54 AM
Hi Steve,
Welcome to VBAX.
You're doing better than me!, I get nothing at all, but continuing to investigate.
BTW, if you wish to post your workbook, click on Go Advanced below the reply box, and then Manage Attachments. You can attach zip files etc.
Regards
MD
mdmackillop
02-25-2005, 12:00 PM
Create a range name "database" for your data
http://support.microsoft.com/default.aspx?scid=kb;en-us;213835
stevewater
02-27-2005, 04:49 AM
Thanks for the Link its working perfectly
Mission completed
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.