Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
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
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 09:56 AM.

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