Results 1 to 3 of 3

Thread: Help with VBA

  1. #1

    Help with VBA



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    This is my first post here and Im in need of help in copy pasting data in a particular format in excel. I have copied grouped textboxes from ppt to excel (as shown in the attachment, column I). i dont want to disturb the format of the grouped boxes in any way.

    Is it possible to replace the text in a textbox (say textbox 1) with text in cell "C6" and similarly for other textboxes (eb textbox 2 contents to be replaced by text in cell "C7".

    Many thanks for your help!

    Best regards
    Attached Files Attached Files

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    102
    Articles
    0
    Excel Version
    365
    Hi,
    If you want to do it manually (there are only 7 textbox) just click on a text box, textbox 1 for example, then in the Formula bar, type = $C$6.

    see the attached file.
    good luck
    Help_Excel_BA.xlsx

  3. #3
    Quote Originally Posted by hossat View Post
    Hi,
    If you want to do it manually (there are only 7 textbox) just click on a text box, textbox 1 for example, then in the Formula bar, type = $C$6.

    see the attached file.
    good luck
    Help_Excel_BA.xlsx
    Thanks a lot for this Hossat! Solves my problem! We can format the cells the same way as we want the text boxes to be! Great
    Last edited by Excel_BA; 2015-07-02 at 07:43 AM. Reason: update

Posting Permissions

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