Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2017, 01:38 PM
gmaxey gmaxey is offline Create a ComboBox in a Form that creates a new document and autofills a textBox Windows 7 32bit Create a ComboBox in a Form that creates a new document and autofills a textBox Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

You certainly don't need all of that code. Assuming your list is small like your example and relatively static:

Code:
Option Explicit
Private Sub UserForm_Initialize()
  With EmpNameList
    .MultiSelect = 1
    .AddItem
    .List(.ListCount - 1, 0) = "Ally"
    .List(.ListCount - 1, 1) = "1234"
    .List(.ListCount - 1, 2) = "Ally"
    .List(.ListCount - 1, 3) = "Ally"
    .AddItem
    .List(.ListCount - 1, 0) = "Linda"
    .List(.ListCount - 1, 1) = "1234"
    .List(.ListCount - 1, 2) = "Jerry"
    .AddItem
    .List(.ListCount - 1, 0) = "Cameron"
    .List(.ListCount - 1, 1) = "6789"
    .List(.ListCount - 1, 2) = "Tom"
  End With
  cmdOK.Enabled = False
End Sub
Private Sub Cost_Center_Change()
  Validate
End Sub
Private Sub Auth_Date1_Change()
  Validate
End Sub
Private Sub Auth_Date2_Change()
  Validate
End Sub
Private Sub cmdOK_Click()
Dim fileName As String
Dim lngIndex As Long
Dim oDoc As Document
  For lngIndex = 0 To EmpNameList.ListCount - 1
    If EmpNameList.Selected(lngIndex) Then
      Set oDoc = Documents.Add("LaborAuthorizationForm.docm") 'You should use a template not a document.
      With oDoc
        'Replace these msgboxes with whatever code you want to use to write to the document targets (i.e., table cells, bookmarks, content controls, etc.)
        MsgBox EmpNameList.List(lngIndex, 0)
        MsgBox EmpNameList.List(lngIndex, 1)
        MsgBox EmpNameList.List(lngIndex, 2)
        MsgBox Cost_Center
        MsgBox Auth_Date1
        MsgBox Auth_Date2
        oDoc.SaveAs2 EmpNameList.List(lngIndex, 0) & "_LaborAuthorizationForm"
        oDoc.Close
        Set oDoc = Nothing
    End If
  Next
End Sub
Private Sub cmdCancel_Click()
  Hide
End Sub
Sub Validate()
  cmdOK.Enabled = True
  If Cost_Center = vbNullString Then cmdOK.Enabled = False
  If Not IsDate(Auth_Date1) Then cmdOK.Enabled = False
  If Not IsDate(Auth_Date2) Then cmdOK.Enabled = False
End Sub
Otherwise you should consider populating the userform listbox using a database.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #2  
Old 02-13-2017, 05:51 AM
BlackGirlMagic's Avatar
BlackGirlMagic BlackGirlMagic is offline Create a ComboBox in a Form that creates a new document and autofills a textBox Windows 7 64bit Create a ComboBox in a Form that creates a new document and autofills a textBox Office 2010 64bit
Novice
Create a ComboBox in a Form that creates a new document and autofills a textBox
 
Join Date: Feb 2017
Location: Washington, DC
Posts: 3
BlackGirlMagic is on a distinguished road
Post

So if I wanted the new document to have textboxes that are filled with the employee name, number, etc. from the previous document how would that look? Would I have to have the textboxes already in the new document (template?) or would the old document create the textbox when it creates the new document?
Reply With Quote
Reply

Tags
combo box, forms vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a ComboBox in a Form that creates a new document and autofills a textBox A form for my own use which creates a document? CactusWren Word 5 08-31-2015 11:22 AM
how to save contents in textbox in VB2013 form into a Word document? saltlakebuffalo Word VBA 6 12-10-2014 06:12 PM
Create a ComboBox in a Form that creates a new document and autofills a textBox Outlook 2007 Code For Matching Textbox to a Combobox in a Different Form lms Outlook 4 07-03-2013 08:34 AM
Create a ComboBox in a Form that creates a new document and autofills a textBox how to populate textbox based on combobox selection in word IvanGeorgiev Word VBA 1 02-21-2013 07:28 PM
Textbox updating from combobox selection paxile2k Word VBA 0 10-26-2010 02:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft