PDA

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