Results 1 to 4 of 4

Write Text to Cell - Failure

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2008
    Location
    Santa Fe
    Posts
    2

    Write Text to Cell - Failure

    Hi,
    I have just started VBA for the first time in Excel 2007.
    I have spent 2-3 hours trying to write text to a cell and I do not understand why it is not working. I have reduced the operation to the simplest form that I can find, now using the following code:

    Public Sub FundTransfer()
        Dim textout As String
        
       
        textout = "test"
        
        Range("H388").Select
        
        ActiveSheet.Cells(1, 1) = textout
        
        
        
        
        
    End Sub
    When I execute this operation, no errors are generated. The program indeeds selects the proper cell, but no text is written. It just stays as a white blank cell with no action taken. I have tried numerous variations all with the same result. I can get the text to display with a MsgBox command, but not with the above code.

    Can anyone help me with the errors of my ways? Thank you very much.

    Clifford E Carnicom
    cec102@usa.com

    (also, I tried a search function on this topic within this forum, but web page came back as an error page with no result. I am a new member here).
    Last edited by cecarnicom; 10-06-2008 at 12:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Append Cell Values To Text Files
    By Stefan.S. in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-17-2008, 11:09 AM
  2. Trying to append text into a cell with different colours
    By Earl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2008, 05:23 PM
  3. Treating a cell as text
    By spr1nt in forum Excel General
    Replies: 1
    Last Post: 07-15-2008, 04:42 AM
  4. Scrolling text in a Cell
    By Robert Bob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2007, 06:47 PM
  5. Replies: 7
    Last Post: 12-22-2006, 06:34 AM

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