Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User forms
I am using Excel 2003. I have a spreadsheet called planning. In one tab,
labelled "plandata", I have my planning data. In a separate tab, I have created a User Form. This form uses selected fields from "plandata", or it will. I want to hide the plandata sheet and display the select fields in my User Form (frmPlanData) for the users to edit. They will NOT add or delete any records in the file - Edit only. I can create the form but can't get it to display the records from the other sheet. Help! Obviously new to forms in Excel. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User forms
Did you fully qualify the ranges in the other sheet, so including the sheet?
Should do something like: With Sheets("planning") ..range etc. End With If this is not the problem then show the relevant code. RBS "Andre7266" wrote in message ... I am using Excel 2003. I have a spreadsheet called planning. In one tab, labelled "plandata", I have my planning data. In a separate tab, I have created a User Form. This form uses selected fields from "plandata", or it will. I want to hide the plandata sheet and display the select fields in my User Form (frmPlanData) for the users to edit. They will NOT add or delete any records in the file - Edit only. I can create the form but can't get it to display the records from the other sheet. Help! Obviously new to forms in Excel. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User forms
I do not have a clue as to what you just said. I have the planning sheet. The
second sheet is blank with my vb code for the user form. On startup I can bring up the form. However, the form comes up blank without any data from planning. When I call the form, is that where I am support to put the "With Sheets("planning")??? Thanks. "RB Smissaert" wrote: Did you fully qualify the ranges in the other sheet, so including the sheet? Should do something like: With Sheets("planning") ..range etc. End With If this is not the problem then show the relevant code. RBS "Andre7266" wrote in message ... I am using Excel 2003. I have a spreadsheet called planning. In one tab, labelled "plandata", I have my planning data. In a separate tab, I have created a User Form. This form uses selected fields from "plandata", or it will. I want to hide the plandata sheet and display the select fields in my User Form (frmPlanData) for the users to edit. They will NOT add or delete any records in the file - Edit only. I can create the form but can't get it to display the records from the other sheet. Help! Obviously new to forms in Excel. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User forms
You will have to explain a bit better what you are doing and show the
relevant code. The second sheet is blank with my vb code for the user form. What exactly do you mean with that? RBS "Andre7266" wrote in message ... I do not have a clue as to what you just said. I have the planning sheet. The second sheet is blank with my vb code for the user form. On startup I can bring up the form. However, the form comes up blank without any data from planning. When I call the form, is that where I am support to put the "With Sheets("planning")??? Thanks. "RB Smissaert" wrote: Did you fully qualify the ranges in the other sheet, so including the sheet? Should do something like: With Sheets("planning") ..range etc. End With If this is not the problem then show the relevant code. RBS "Andre7266" wrote in message ... I am using Excel 2003. I have a spreadsheet called planning. In one tab, labelled "plandata", I have my planning data. In a separate tab, I have created a User Form. This form uses selected fields from "plandata", or it will. I want to hide the plandata sheet and display the select fields in my User Form (frmPlanData) for the users to edit. They will NOT add or delete any records in the file - Edit only. I can create the form but can't get it to display the records from the other sheet. Help! Obviously new to forms in Excel. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms | Excel Programming | |||
User forms help | Excel Programming | |||
User Forms | Excel Programming | |||
User Forms | Excel Programming | |||
User forms | Excel Programming |