+ Reply to Thread
Results 1 to 7 of 7

Change USerFrom1.show

  1. #1
    Registered User
    Join Date
    05-03-2020
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    9

    Lightbulb Change USerFrom1.show

    Hello guys, how to retrieve data from excel cells,

    for example the data in cell A1 = UserForm1

    then in VBA
    the text is the same as UserForm1 too, so if you change the other text too

    Please Login or Register  to view this content.


    Sorry my english is not good, I guess guys understand mymind, thankyou
    Last edited by regentrei88; 05-04-2020 at 11:10 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,232

    Re: Change USerFrom1.show

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,912

    Re: Change USerFrom1.show

    Why CallByName instead of just Userforms.Add(Name).Show?
    Rory

  4. #4
    Registered User
    Join Date
    05-03-2020
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    9
    Quote Originally Posted by sintek View Post
    Please Login or Register  to view this content.

    Thank you,because im still beginner here, the file no running yet?
    Attached Files Attached Files

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,232

    Re: Change USerFrom1.show

    True...tx Rory
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-03-2020
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    9

    Re: Change USerFrom1.show

    Thank you very much , I can do it

  7. #7
    Registered User
    Join Date
    05-03-2020
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    9

    Re: Change USerFrom1.show

    sorry once again master, how to change be hyperlink?

    example:
    =hyperlink(A1;"Open Form")

    Is it possible?

    thank you

+ 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. Chart to show Ranking Change
    By jp16 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-06-2018, 12:28 PM
  2. Show Image on change
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2016, 03:12 PM
  3. change code to show output as hh:mm
    By redspanna in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2015, 11:06 AM
  4. I want to change a column to show milliseconds
    By SupermariaPan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2014, 12:41 PM
  5. Need formula to show amount of change (+ or -)
    By Alec S. in forum Excel General
    Replies: 1
    Last Post: 03-09-2010, 03:22 PM
  6. Replies: 1
    Last Post: 04-11-2008, 02:02 AM
  7. Change to show time
    By M Jones in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 07:05 PM

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