+ Reply to Thread
Results 1 to 10 of 10

Floating Userform with ActiveCell.Formula text box

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Floating Userform with ActiveCell.Formula text box

    I have this user-form which shows, in a text box, the string in the selected cell. The form then allows the fonts of each character to be manipulated by selecting an option, in this case Arial, Calibri and Times New Roman.
    The form is made floating by setting the property "ShowModal" to False.
    It works quite well except that when I change cells, I want the value of ActiveCell.Formula in the text box to change as well.
    Can't seem to attach Workbook.

    Snapshot.png

    FORM CODE
    Please Login or Register  to view this content.
    MODULE
    Please Login or Register  to view this content.
    Attached Images Attached Images

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Floating Userform with ActiveCell.Formula text box

    Hi,

    Add the following code to the top of the userform code module
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Floating Userform with ActiveCell.Formula text box

    It does change the value of ActiveCell.Formula in the text box ... but I can't edit the fonts within the form.

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Floating Userform with ActiveCell.Formula text box

    I can't say why that would be, so I suggest you attach the file here.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Floating Userform with ActiveCell.Formula text box

    Please find attached.
    Attached Files Attached Files

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Floating Userform with ActiveCell.Formula text box

    Works OK here. What happens when you try to edit the font?

  7. #7
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Floating Userform with ActiveCell.Formula text box

    It works on the first selection, but on the others, nothing happens.

  8. #8
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Re: Floating Userform with ActiveCell.Formula text box

    Apologies, it does work. I must have done something wrong.
    Much appreciate the assistance.

  9. #9
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Floating Userform with ActiveCell.Formula text box

    You're welcome.

  10. #10
    Registered User
    Join Date
    12-12-2017
    Location
    china
    MS-Off Ver
    2013
    Posts
    2

    Re: Floating Userform with ActiveCell.Formula text box

    make a mark and see this case later

+ 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. [SOLVED] Floating userform
    By IGEDIT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2013, 07:16 AM
  2. Floating Userform
    By Shazz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-27-2012, 11:02 AM
  3. activecell formula not including cell range text
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2011, 05:32 AM
  4. show changing activecell value in floating userform
    By tenk283 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2010, 02:25 AM
  5. Floating Userform
    By tenk283 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2010, 01:21 AM
  6. Userform Text Based on ActiveCell
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 08:41 AM
  7. floating userform
    By engrzubair in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2006, 11:53 AM
  8. [SOLVED] Floating userform
    By MD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2005, 12:06 AM

Tags for this Thread

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