Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Coding Help
HI Tom,
Thanks SO much for your reply. In the interim I got just about as far as you described. I can get it to display when I run it but not when I File menu, New and create a new workbook based on my template. Here is the code so far: In Module 1: Sub ShowForm() UserForm1.Show End Sub In UserForm: Private Sub CommandButton1_Click() 'Insert text from textboxes into cells With ActiveDocument Worksheets("Sheet1").Range("A1") = TextBox1.Text Worksheets("Sheet1").Range("A3") = TextBox2.Text End With UserForm1.Hide End Sub It works and enters the values into the cells but I can't get it to launch the userform when I File menu, New, choose the templates and click OK. Any hints? THANKS SO MUCH!!! Next I have to tackle combo boxes as I have to create a purchase order workbook! Yikes. Shauna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Coding Help
in the vbe, look in the project explorer and find the ThisWorkboook item
under you project. Right click on that and select view code. In the left dropdown, select workbook in the right dropdown, select Open Private Sub Workbook_Open() End sub Call you macro i this event - the workbook_open event Private Sub Workbook_Open() If ThisWorkbook.Path = "" then ShowForm end if End sub This event fires when the workbook is opened. In your code, you don't need With ActiveDocument End With 1) you don't use it 2) there is no activedocument in Excel - this is a Word concept. there is an activeSheet, but you have specified the sheet already. -- Regards, Tom Ogilvy Shauna Koppang wrote in message ... HI Tom, Thanks SO much for your reply. In the interim I got just about as far as you described. I can get it to display when I run it but not when I File menu, New and create a new workbook based on my template. Here is the code so far: In Module 1: Sub ShowForm() UserForm1.Show End Sub In UserForm: Private Sub CommandButton1_Click() 'Insert text from textboxes into cells With ActiveDocument Worksheets("Sheet1").Range("A1") = TextBox1.Text Worksheets("Sheet1").Range("A3") = TextBox2.Text End With UserForm1.Hide End Sub It works and enters the values into the cells but I can't get it to launch the userform when I File menu, New, choose the templates and click OK. Any hints? THANKS SO MUCH!!! Next I have to tackle combo boxes as I have to create a purchase order workbook! Yikes. Shauna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Coding Help
Hi Tom, Again THANKS SO MUCH for your help. Got it working now. My next task today is to develop a listbox or ComboBox that then links to a VLookup table in the same workbook on another sheet. I remember glimpsing some coding in my search for text box coding. Any hints on this or where to look? I will dilligently be searching for this coding this morning. Just for a background I have been given a project to create a combination Purchase Order/Accounts Payable Voucher workbook where the purchasing agent fills in most of the information on the Purchase order and it links to fields in the AP Voucher. Lots of pick lists and VLookup tables which I can do, but they would like it automated with a Userform to help the fill-in process. Hence my struggles... particularly seeing I an a rank VB beginner. So thanks for your patience:-) Shauna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
sum by coding | New Users to Excel | |||
TextBox Coding Help | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |