+ Reply to Thread
Results 1 to 2 of 2

Change Textbox written, properties (VBA)

  1. #1
    Registered User
    Join Date
    07-26-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    0

    Change Textbox written, properties (VBA)

    Hi,

    I tryed the following code, to change the size of the font of the TextBox that is written the name in the TextBox 'txtboxselection'. For example if the text of the TextBox 'txtboxselection' is 'TextBox1' then it should change the font size of the TextBox1.

    Please Login or Register  to view this content.
    But, unfortunately it doesn't work ('Compile Error: Type mismatch'). So is there any way to tell the program that I want to change the font size of the TextBox written in the "txtboxselection' TextBox, because mine didn't work.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello dan3939,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Powerpoint textbox properties via Excel VBA
    By stoffeltotof in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2017, 06:34 AM
  2. [SOLVED] Using a class to change textbox properties
    By Journeyman3000 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2015, 05:09 PM
  3. [SOLVED] Filter Column by TExtbox written data
    By brainzlp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-08-2015, 03:35 PM
  4. [SOLVED] Change the properties of a userforn textbox based on the backcolor of a label
    By chipnputt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:47 PM
  5. Take what is written in a textbox and put it in a cell on specific worksheet
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2011, 02:06 AM
  6. How to reference cell properties where function is written?
    By Lepista in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2010, 07:53 AM
  7. Set Properties of TextBox in VBA
    By Don Rouse in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1