Outlook Template - textbox visible based on combobox selection

Status
Not open for further replies.

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

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
 
Status
Not open for further replies.
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
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 1
HarvMan Outlook.com Account Using Outlook 3
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 4
D Alerts in outlook Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
L Recommendations for Utility to Backup Outlook 365 Account Settings Using Outlook 0
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 4
T How to configure Outlook for two users on a single Windows account Using Outlook 3
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
B Outlook 213 keeps crashing. I just found out there are DMP files. How can I tell Why? Using Outlook 2
H Outlook 2016 related mails in outlook Outlook VBA and Custom Forms 13
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1

Similar threads

Top