+ Reply to Thread
Results 1 to 20 of 20

Userform textbox used as refedit

Hybrid View

Jacques Grobler Userform textbox used as... 06-27-2012, 02:16 AM
Winon Re: Userform textbox used as... 06-27-2012, 02:43 AM
Jacques Grobler Re: Userform textbox used as... 06-27-2012, 03:43 AM
Jacques Grobler Re: Userform textbox used as... 06-27-2012, 04:51 AM
Winon Re: Userform textbox used as... 06-27-2012, 05:33 AM
snb Re: Userform textbox used as... 06-27-2012, 05:52 AM
Winon Re: Userform textbox used as... 06-27-2012, 06:08 AM
snb Re: Userform textbox used as... 06-27-2012, 06:39 AM
Jacques Grobler Re: Userform textbox used as... 06-27-2012, 07:33 AM
Jacques Grobler Re: Userform textbox used as... 06-27-2012, 08:05 AM
snb Re: Userform textbox used as... 06-27-2012, 08:10 AM
Jacques Grobler Re: Userform textbox used as... 06-27-2012, 08:28 AM
snb Re: Userform textbox used as... 06-27-2012, 09:43 AM
Jacques Grobler Re: Userform textbox used as... 06-28-2012, 01:29 AM
Jacques Grobler Re: Userform textbox used as... 06-28-2012, 02:13 AM
Jacques Grobler Re: Userform textbox used as... 06-28-2012, 08:26 AM
Jacques Grobler Re: Userform textbox used as... 06-29-2012, 01:45 AM
  1. #1
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Userform textbox used as refedit

    Click the start button.
    change a value in textbox3 (that contains 20 when opening): e.g into 200
    Look at the userform's caption.
    Attached Files Attached Files



  2. #2
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: Userform textbox used as refedit

    Here is what I'd like to achieve with a textbox, however, I have probable not played enough with the concept to adapt it to what I require, but in any case, here is the site:

    http://peltiertech.com/WordPress/ref...l-alternative/

    SNB, thanks for the reply, I'll have a look at your suggestion as well.
    Jacques


  3. #3
    Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    2007, 2010, 2016
    Posts
    275

    Re: Userform textbox used as refedit

    Just a spanner in the works, if I start in a clean cell, and I start typing P for PI(), it gives me an error because it doesn't recognise the formula as a value, but rather as a string.

    I'm trying to work around this but I am struggling with this. Even if you take let's say textbox1 and you select the cell and start clearing by pressing backspace, you get an error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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