Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User selection
Hi Everyone,
Need some help to finish a project. The procedure requests user to select a column in a worksheet by either selecting the entire column or just selecting a single cell in that column. The idea is that once selection is made, data would be generated from that column. However, I am not sure how do I determine which column in the work sheet was selected by the user. Any help is appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User selection
Try something like this :
Set rngSelection = Application.InputBox( _ Prompt:="Select cell(s) (use CTRL key to select more than one)", _ Title:="your title", _ Default:=ActiveCell.Address, _ Type:=8) this will return a range object after the user has selected something Rgds Rog -----Original Message----- Hi Everyone, Need some help to finish a project. The procedure requests user to select a column in a worksheet by either selecting the entire column or just selecting a single cell in that column. The idea is that once selection is made, data would be generated from that column. However, I am not sure how do I determine which column in the work sheet was selected by the user. Any help is appreciated. Thanks in advance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User selection
ActiveCell.Column
-- Regards, Tom Ogilvy "Samir" wrote in message ... Hi Everyone, Need some help to finish a project. The procedure requests user to select a column in a worksheet by either selecting the entire column or just selecting a single cell in that column. The idea is that once selection is made, data would be generated from that column. However, I am not sure how do I determine which column in the work sheet was selected by the user. Any help is appreciated. Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User selection
Samir,
If you want just the column number, use code like Dim ColNum As Integer ColNum = ActiveCell.Column If you want a Range reference to the column, use Dim ColRng As Range Set ColRng = ActiveCell.EntireColumn ' or Set ColRng = Application.Intersect(ActiveSheet.UsedRange, ActiveCell.EntireColumn) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Samir" wrote in message ... Hi Everyone, Need some help to finish a project. The procedure requests user to select a column in a worksheet by either selecting the entire column or just selecting a single cell in that column. The idea is that once selection is made, data would be generated from that column. However, I am not sure how do I determine which column in the work sheet was selected by the user. Any help is appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table limiting user selection | Excel Discussion (Misc queries) | |||
VBA Code User Range Selection | Excel Discussion (Misc queries) | |||
Displaying a result based on user selection | Excel Discussion (Misc queries) | |||
Calculate average based on user selection | Excel Discussion (Misc queries) | |||
Generate a value from user selection in list box. | Excel Discussion (Misc queries) |