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
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 8
L Opening People Outlook 2021 Using Outlook 1
e_a_g_l_e_p_i Outlook 2021 not letting me setup my Gmail using pop Using Outlook 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
M Outlook 2016 outlook vba to look into shared mailbox Outlook VBA and Custom Forms 0
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 2
O Outlook - Switch from Exchange to IMAP Using Outlook 0
e_a_g_l_e_p_i Is it possible to have a reminder in Outlook 2021 for every 90 days Using Outlook 3
farrissf Outlook 2016 Optimizing Email Searches in Outlook 2016: Seeking Insights on Quick Search vs Advanced Search Features Using Outlook 0
C Advanced search terms for "Outlook Data File" Using Outlook 1
N Reply to Outlook messages by moving messages to a specific Outlook folder Outlook VBA and Custom Forms 1
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
A Outlook 365 (OutLook For Mac)Move "On My Computer" Folder Items From Old To New Mac Computer Using Outlook 3
H Integrating Alexa & Outlook Pro 2021 Using Outlook 2
Z Automatically adjust Outlook Reading Pane from bottom to right depending on portrait or landscape window Using Outlook 1

Similar threads

Top