Results 1 to 3 of 3

apply textbox input to selected cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    Excel 2010
    Posts
    1

    apply textbox input to selected cells

    Hi,

    I'd like to know whether it is possible to input a text from textbox to a number of selected (non-contiguous) cells.
    Basically, I need to write in a textbox, click on the related button and populate previously selected range of cells.
    I do not know how to go ahead (from line ! onwards), other than just being able to input a pre-set text ("y" in my example) in the selected cells.

    Range("I2").Select
        ActiveCell.Offset(1, 0).Select
        Do Until ActiveCell.Height <> 0
        ActiveCell.Offset(1, 0).Select
        Loop
        Range(ActiveCell, Cells(ActiveCell.Row + 3000, ActiveCell.Column)).Select
        Selection.SpecialCells(xlCellTypeVisible).Select
    !   Selection.FormulaR1C1 = "y"
    Thanks in advance.
    Giuseppe
    Last edited by crypta8; 08-30-2012 at 05:40 AM. Reason: wrong thread title

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