Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Userform from another workbook
On my userform, there is a command button that goes to a worksheet in another workbook. This new worksheet serves as a sort of database for companies. Each company is listed in a row with a commandbutton to the left of the company information that will populate the userform from the first workbook. I am having problem with my code for this action
Private Sub CommandButton1_Click( Workbooks("Workflow Engine").Worksheets("FLAT DIP(S)").Activat Unload UserForm12FLATDIPSAppraisa UserForm12FLATDIPSAppraisal.TextBox2.Text = Workbooks("CARDEX TEST").Sheets("AppraisalCardex").Range("C3" UserForm12FLATDIPSAppraisal.TextBox3.Text = Workbooks("CARDEX TEST").Sheets("AppraisalCardex").Range("D3" UserForm12FLATDIPSAppraisal.TextBox4.Text = Workbooks("CARDEX TEST").Sheets("AppraisalCardex").Range("F3" UserForm12FLATDIPSAppraisal.TextBox5.Text = Workbooks("CARDEX TEST").Sheets("AppraisalCardex").Range("E3" UserForm12FLATDIPSAppraisal.TextBox6.Text = Workbooks("CARDEX TEST").Sheets("AppraisalCardex").Range("B3" UserForm12FLATDIPSAppraisal.Sho End Su The problem occurs when I Unload the Userform. I have exhausted my knowledge of VBA (which took all of 30 sec.) and I can't figure out how to fix this problem I had this working perfectly when the database of companies was part of the original workbook. My boss decided that he wanted the users to have the appearance of not leaving the screen, so that is why I am trying to use this other workbook. Another question that I have is can you set the size of a window in VBA? Because I would like to be able to set how big the database workbook is so that users feel like they never left the original workbook screen Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i re-populate a userform with data already entered? | New Users to Excel | |||
Populate combo box for Userform in Excel 2002 | Excel Programming | |||
Pick cell and populate userform | Excel Programming | |||
Userform using 3 ranges to populate. | Excel Programming | |||
Range of Cells to populate in a text box on a userform | Excel Programming |