Microsoft Office Forums new thread

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2012, 07:19 AM
gsrikanth gsrikanth is offline new thread Windows XP new thread Office XP
Competent Performer
new thread
 
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

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
new thread Yet Another Missing Email Thread DrewD Outlook 4 08-19-2011 01:51 PM
new thread 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 06:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft