Excel Cell opens Specfic Cells

[gjmac2]

I have a general question. Is it possible to create a table in Excel with column headers that, when clicked, will allow allow data entry to specific assigned cells?

For example, say that every time I clicked the Name in column B Row 1, that Cells B4 through B8 would open for data entry. Is this possible?

Thanks in advance.

 

[kjv1611]

Here's a little bit about using the SelectionChange control in order to do what you are asking:

http://excel.tips.net/Pages/T003070_Mouse_Click_Event_in_VBA.html

If you're unsure as to how to do that, you could also get started by:
[ol][li]Start recording a macro.[/li]
[li]Click the Cell you want to say is being clicked.[/li]
[li]Stop recording the macro.[/li]
[li]Find the code in the VB Editor Window where your macro is stored, and review it. You can change it or copy/paste it to a new module to attempt what you're trying to accomplish.[/li][/ol]

That would just be a start, by the way

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Cells B4 through B8 would open for data entry

What does that mean, "open for data entry"?

Do you have PROTECTION on this sheet?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gjmac2]

No. What I mean is when you click on cell B1, that it would activate cells B4 through B8 for data entry. If B1 is not clicked, then the cells are closed.

 

[SkipVought]

What does OPEN or CLOSED cells mean? That is not a common concept in Excel.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gjmac2]

Sorry if I am not being clear. I just want to enable data entery to specific cells a given column when the header for that column is clicked. Does that make sense?

 

[SkipVought]

You can only enter data in one cell at a time, unless the cells are merged. Are you referring to MERGING the cells in the range indicated?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gjmac2]

Let me try this another way.

Let's say I have 3 columns, and there are 10 rows. Now when I click the header column A, then calls A1, A2 and A3 are each available for dataentry. Now, when I click the header for column B, cells B4, B5 and B6 are available for data entry, but not B1, B2 or B3. Finally, when colum the header for column C, cells C7, C8, C9 and C10 are available for data entry, but not cells C1 through C6. Does this make sense now?

 

[SkipVought]

So you want every cell LOCKED and worksheet protection ON, until one of these events, in which case the appropriate LOCKED cells become UNLOCKED, allowing ONLY those cells to be edited. Correct?

On a separate sheet, create a table that describes the ranges that you want UNLOCKED in each column. Post back with the table you have designed.

Turn on your macro recorder and record LOCKING all cells.

Turn on your macro recorder and record UNLOCKING a range.

Turn on your macro recorder and record PROTECTING the sheet.

Turn on your macro recorder and record UNPROTECTING the sheet.

Post back your recorded code.





Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]