Outlook Template - textbox visible based on combobox selection

Status
Not open for further replies.
T

The Trooper

Member
Outlook version
Outlook 2013 64 bit
Email Account
Outlook.com (as MS Exchange)
Hi,

Firstly, I apologize if I use the wrong terms, I'm a newbie to all of this - I'm trying to design an Outlook Template where a textbox becomes visible based on a Combobox selection. I was trying to use an iif function within the properties section of the textbox, but no luck...Help!!!

....thanks in advance!
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I don't have any code samples offhand - but if you can find a sample for Excel or word, it can be used in outlook with minor tweaking.


Code: 
Private Sub CommandButton1_Click()
    Dim x As Long
     For x = 1 To 2
        Me.Controls("TextBox" & x).Visible = Not Me.Controls("TextBox" & x).Visible
        Me.Controls("Label" & x).Visible = Not Me.Controls("Label" & x).Visible
    Next x
End Sub

Private Sub CommandButton1_Click()
    Dim x As Long
    For x = 1 To 2
        Me.Controls("TextBox" & x).Visible = Not Me.Controls("TextBox" & x).Visible
        Me.Controls("Label" & x).Visible = Not Me.Controls("Label" & x).Visible
    Next x
End Sub

that sample was from

Visible and enable textbox based on combobox selection - OzGrid Free Excel/VBA Help Forum

I believe this is a change event but what I have written will not execute (Code, 8 lines)
www.ozgrid.com www.ozgrid.com
 
Status
Not open for further replies.
< contact list seen in Contact folder but knot in Address book or when 'TO' button is clicked in new email | Auto remove [EXTERNAL] from subject >
Similar threads
Thread starter Title Forum Replies Date
M Outlook 2010 How could I globally redesign an outlook template form/region/inspector template used to display mail lists or an individual mails? Outlook VBA and Custom Forms 0
L Outlook saved template function too limited Using Outlook 2
K Outlook template Using Outlook 1
M Reply Inline With a Outlook Template Outlook VBA and Custom Forms 6
D Macro sending outlook template from Excel list Outlook VBA and Custom Forms 6
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
Diane Poremsky Using the Outlook Calendar Template Using Outlook 0
Q Editing an outlook. Template file (Otk) Using Outlook 1
M Update field codes when opening Outlook Template Outlook VBA and Custom Forms 2
J Outlook template with environ varaibles Outlook VBA and Custom Forms 0
N Creating or changing the main new mail message template in Outlook 2010 Using Outlook 2
T My Outlook Calendar Template Using Outlook 1
J VBS Script (macro) for word to open Outlook template. Outlook VBA and Custom Forms 2
B Outlook to Word Template error Using Outlook 4
J Adding original email text to outlook message template Outlook VBA and Custom Forms 2
D outlook 2010 template accessable to others at work... Using Outlook 1
W Change Template Recipient Automatically - Outlook 2007 Using Outlook 5
R How to use an outlook template globally in an organization Using Outlook 1
H Macro to load an Outlook Template Using Outlook 2
O automate dates in outlook template Using Outlook 1
R Outlook Template: Looking to distribute a VBA Outlook template to other people Using Outlook 1
A outlook printing assistant Help editing template Using Outlook 3
F CAN'T SAVE OUTLOOK 2010 E-MAIL TEMPLATE (.oft) Using Outlook 1
L Idiot's guide to amending My Outlook Calendar template Using Outlook 11
N How to automatically update all fields in an Outlook message template (OFT)? Using Outlook 9
G Populate an Outlook 2007 template with spreadsheet data. Outlook VBA and Custom Forms 1
L How do I add another template to Outlook Outlook VBA and Custom Forms 1
J populate word template from Outlook custom form Outlook VBA and Custom Forms 2
S Sending Email from Access 2007 through Outlook 2007 using template Outlook VBA and Custom Forms 13
D "Outlook has blocked access to this form template file. Outlook VBA and Custom Forms 3
C Outlook record the step I take getting to the user template? Outlook VBA and Custom Forms 1
S Re: Cannot attach a file to an Outlook 2007 template after installingOffice 2007 SP2 Outlook VBA and Custom Forms 3
S Choosing different reply template in Outlook 2000 Outlook VBA and Custom Forms 1
T Outlook 2007 Form Template Icon Outlook VBA and Custom Forms 1
Retired Geek Outlook for the MAC with Yahoo accounts now very broken Using Outlook 6
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
L How Stop Outlook Nag Messages Using Outlook 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 1
L I Cannot Sign Into My Outlook Account? Outlook VBA and Custom Forms 0
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0
e_a_g_l_e_p_i Question about installing my Gmail account on my iPhone but still getting messages downloaded to my desktop Outlook. Using Outlook 3
F Want to add second email to Outlook for business use Using Outlook 5
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
Z Outlook 2021 Outlook new emails notification not working Using Outlook 5
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
V How to use Comas in a picklist in Outlook forms Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Question about reinstalling Outlook 2021 Using Outlook 5

Similar threads

Top