Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-24-2012, 07:19 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default new thread

in my excel file, only i need to do click
on first click on cell, get one, then two like this so on

this below vb code, is gave an idea row name, but i need on click one, two , three, four so on

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim RowOffset As Long
Dim IndexCol As String
'Set values
RowOffset = 0
'Change the C to the column where you want the numbers to show
IndexCol = "C"

Intersect(ActiveCell.EntireRow, Columns(IndexCol)).Value = ActiveCell.Row + RowOffset
End Sub

once again Thank jb


Edit/Delete Message
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why nobody marks his thread as solved?! Catalin.B Excel 0 08-24-2011 06:23 AM
Yet Another Missing Email Thread DrewD Outlook 4 08-19-2011 01:51 PM
Publisher 2003 Help making even spaced dots (Thread has 2 images for examples) Blitz55 Publisher 3 10-29-2010 01:25 PM
Mark a thread as solved Matrix Forum Support 0 04-22-2009 04:48 PM


All times are GMT -7. The time now is 02:25 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft