+ Reply to Thread
Results 1 to 2 of 2

manipulate a cell value in excel 2010

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    12

    manipulate a cell value in excel 2010

    i have a userform..and on clicking ok the excel sheet behind is populated..if the value in a cell is -1 then the cell should turn empty as in the cell should contain no value.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: manipulate a cell value in excel 2010

    On your userform command button click add the below lines.........

    Please Login or Register  to view this content.
    Change the cell reference A10 to your desired cell.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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