Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2016, 02:28 AM
AJMiveld AJMiveld is offline Formating Active X Text Box Windows 7 32bit Formating Active X Text Box Office 2016
Novice
Formating Active X Text Box
 
Join Date: Mar 2016
Posts: 1
AJMiveld is on a distinguished road
Default Formating Active X Text Box

Hello All

i am hoping someone can help me in regards to formatting an active X textbox automatically with VBA

I am using the following formula (Among Others) to sum together 3 text boxes
I would like both the input and output text boxes to be formatted to a number/currency
I also have some other Active X text boxes that i would like formatted to %

On Error Resume Next
N = 1 / 0 ' cause an error
If Err.Number <> 0 Then
N = 1
End If
TextBox21 = (Val(TextBox8)) + (Val(TextBox14)) + (Val(TextBox20))





Do i include a format element in the formula or do i format the text box as separate VBA code

Many Thanks
Al
Reply With Quote
Reply

Tags
active x textbox, formatting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Helg formating text field andi_bln Word VBA 4 10-16-2015 03:33 AM
Chart Formating with ChartTitle Font and DataLabel Formating shilabrow Excel Programming 0 06-30-2014 10:01 AM
Formating Active X Text Box Text Box Active X Control DawnK2018 Word 3 11-04-2013 11:17 PM
A text box (active X) control doesn't work on reopening the file Chris Baker PowerPoint 1 06-07-2013 05:51 AM
Formating Active X Text Box Copying text from another to Active document AlexTeslin Word VBA 1 03-08-2013 09:06 PM

Other Forums: Access Forums

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


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