Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Live
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Live
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, "Karen53" wrote: 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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Live
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...;en-us;q110462 XL: ShowDataForm Method Fails If Data Can't Be Found Karen53 wrote: 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, "Karen53" wrote: 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, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
live scrolling | Excel Discussion (Misc queries) | |||
Help With Using Live Data - DDE | Excel Discussion (Misc queries) | |||
Show value in Data Table but not on live chart | Charts and Charting in Excel | |||
Live link from the Web? | Excel Programming | |||
scrollbar control of a chart, live or not live | Excel Programming |