How to display different data forms kept in same worksheet using macro

[pratikghosh]

I have several small data tables (databases) in a single worksheet. If I select any cell within any of the data table and call for Form, it displays the corresponding data form. But if I do exactly the same through a macro, it displays the top left form, irrespective of the cell (or range) I select elsewhere in the sheet.

e.g.

say I have two databases on the same sheet named: forex_rate and fixed_expenses whereby forex_rate is the top left table.

my code

Please Login or Register  to view this content.

....
will display the forex_rate form!

How to rectify?

[royUK]

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

[royUK]

It's usually best to have each table on a different sheet. I think you might need to build your own form, see the example here

http://www.excel-it.com/vba_examples.htm

If the tables are identical in structure you could make your own form that works with each table