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
T Outlook roaming signatures Using Outlook 4
S Adding a recipient's column to Sent folder in Outlook 2010 Outlook VBA and Custom Forms 1
J Outlook search bar in Office 2021 Professional Using Outlook 0
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
C How to fix outlook continuing to prompt fo an Exchange password Using Outlook 0
C Outlook doesn't feel reliable, anymore Using Outlook 5
J Outlook 2016 Trying to get Outlook 2016 to work with Office 365 Using Outlook 0
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
U Outlook not responding when trying to print Emails Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
S Sync Outlook (2021) tasks with Microsoft To Do Using Outlook 1
L Duplicate calendar entries in Outlook 365 Using Outlook 4
V Outlook 2021 Can anyone explain why my Outlook views keep changing?! Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 5
S Outlook 2021 How to customize colors Outlook 2021 & Office 2021 on PC Using Outlook 2
D Outlook 2007 Recovering E-Mails Using Outlook 0

Similar threads

Top