Get Selected Object Name

Hello everyone,

I'm currently working on a smaller project in VBA. To set up an "Edit" function I need to pass the name of a selected object. So far the output works great for the name of cells. But when I select my (grouped) shape there is no output. Although the name of the object is displayed in the small window at the top left. How could I solve this problem?

To explain: The application is a project management tool. Operations planning takes place on a kind of Kanban chart. A form (grouped) is generated for each project and named with a unique continuous ID. If I now click on one of the Kanban cards I have to be able to pass the name of the object in order to set up an "edit" function. So that the form that opens knows which line it should pull its data from and where it should then write the changes. Right now it only outputs a "no object selected" message if i click a merged cell and the "Selected Object Name: " & selectedObjectName when I click on a cell. however not if i click on the kanban card.

Here is the code. This will then be triggered later in the sheet using the function below when the selection is changed:

Please Login or Register  to view this content.

see big yellow banner - how to upload your workbook - far easier to then give specific solution.

Originally Posted by Marc L

So weird and useless !

Completely unnecessary comment. Please be constructive.

Originally Posted by niri2506

Here is the code.

Administrative Note:

Welcome to the forum.

We recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have done this for you.

@niri2506

How about not being the typical "meh you didn't follow the rules"guy but instead actually providing a solution? That would be truly wonderful thanks.

Two posts here and you are already criticising those offering to help you. If a member asks for a workbook, there is a reason for it. It has NOTHING to do with rules. If you want a solution, please comply with the request for a workbook.

This is basic enough so you don't actually require the workbook.

Not your call: YOU are the one asking for help. Your helper will decide what is and what is not necessary in order to assist you.

Do not make rude and ungrateful comments like this to your helpers again. It will NOT be tolerated here. Thank you.

Moderator

It's your choice of vocabulary, Marc (I know English is not your first language). The word 'useless' carries a pejorative sense: you should use 'unnecessary' instead. 'Weird' would be better changed to 'strange'.

As you wrote it, it was for from constructive to a native English-speaking person. I suggest you stop using the term 'useless' from now on.

Administrative Note:

You really need to have a good read of our forum rules and guidelines!

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: http://www.vbaexpress.com/forum/show...ed-Object-Name)

Thanks Ali !

On my side both - useless vs unnecessary - are pretty the same (useless shorter to write), no pejorative will …

But you are NOT a native English speaker - I am. If you suggested a change in my use of French, I would accept it as a non-native French speaker.

Please do NOT use the word 'useless' again (this is an instruction, NOT a request).

OK - thanks for clarifying.

Originally Posted by Marc L

On my side both - useless vs unnecessary - are pretty the same (useless shorter to write), no pejorative will

Let me offer another perspective.
Rather than giving an evaluation of how bad you think a technique is, stick to facts. Instead of

So weird and useless !

you can say

This can be done another way. Here is an example:

That's the difference between critical and constructive.