Table Live

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen53 - 16 Sep 2007 01:04 GMT

Hi,

Is there a way you can show a table (or named range) live in a userform like
can be done in access? By live I mean changes can be made to the table and
they are saved.

Thanks,

Reply to this Message

Karen53 - 16 Sep 2007 06:44 GMT

Hi,

I see the data form which would work but I need to limit the length of the
range. I've tried to set it to my named range but this was unsuccessful.

Range("Types").Select
Sheets("Table").ShowDataForm

I've tried it as activesheet as well. Won't this feature accept a named
range? Is there a way to set this row limit?

Thanks,

> Hi,
>
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

Dave Peterson - 16 Sep 2007 13:40 GMT

Without knowing what Range("Types") is (does it include the headers???)

with sheets("table")
.range("Types").name = "'" & .name & "'!database"
.showdataform
end with

It looks for a name of "database".

Some more info:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q110462
XL: ShowDataForm Method Fails If Data Can't Be Found

> Hi,
>
[quoted text clipped - 16 lines]
> >
> > Thanks,

Signature

Dave Peterson

Reply to this Message