Thread: Data entry forms using macros and buttons

I am trying to enter data into a table which is split into two sides using data entry forms.
This works just fine manually, but when I try to automate it and use macros operated by a buttons (input part a) and (input part b) I only get the data entry form form for part a despite first selecting the cells for part b. I have tried a couple of ways of doing it, see code below

For part a

Code:

Range("a1:b10").select
ActiveSheet.DataEntryForm

For part b

Code:

Range("d1:e10").select
ActiveSheet.DataEntryForm

I have left column c blank to split the table

I have also tried using Column.Select which also didn't work. When I press button for part b it brings up the data entry form for part a.

Any ideas?

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

Code Tags entered this time

Why have you split the table?

I fairly sure that the inbuilt DataForm does not work with two tables on one sheet