VBA Code to Open Data Form

**boogie87** · 01-18-2012, 04:59 AM

Hi all,

I'm looking to make a button which will open the Data Form window, essentially to use Excel as a database. Does anyone know what the correct code is to do this?

**Kyle123** · 01-18-2012, 05:34 AM

Hi

Maybe:

 ActiveSheet.ShowDataForm

**boogie87** · 01-18-2012, 08:54 AM

Thank you for your reply. I'm still getting an error message "ShowDataForm method of Worksheet class failed"

Here is what I'm currently using:

ActiveSheet.ShowDataForm
Range("A8").Select
ActiveSheet.ShowDataForm

I need the range to start from A8 if its possible.

**Kyle123** · 01-18-2012, 09:08 AM

For this to work, you need to have a database to set up, so you at least need column headers

**boogie87** · 01-18-2012, 09:46 AM

I do have headers but they on row 8, does this create the issue?

**boogie87** · 01-18-2012, 10:12 AM

Also, I only need the VBA code to open a 'data form' not a custom made User Form

**OnErrorGoto0** · 01-18-2012, 10:15 AM

If I remember aright, you have to name the range 'Database' if it does not begin within A1:B2

**boogie87** · 01-18-2012, 10:38 AM

I can get the code to run properly until the open data form part. It will select cell A8 but then won't open the form.

**OnErrorGoto0** · 01-18-2012, 10:41 AM

As per my previous post, either the data must start within the range A1:B2 or you have to name the range 'Database' (formula tab, name manager). Without that the code will not work.

**royUK** · 01-18-2012, 10:54 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here