VBA Validation.InputMessage Help

**asaysamone** · 05-24-2022, 12:21 PM

I'm trying to dynamically generate a hover InputMessage but I'm struggling because I keep getting a "Run-time error 1004: Application-defined or Object-defined error"

I have a "player sheet" and a "bracket sheet". On the player sheet, the first column has a team name and the second column has players in it as one cell. When I generate the bracket sheet dynamically, I'm using the team names. When this is being created, I want to also generate a hover InputMessage that will show the second players name on that team when I hover over it.

I've tried

Worksheets("bracket sheet").Range("B1").Validation.InputMessage = Worksheets("player sheet").Cells(2, "A").value
I get the above error when doing this

When I remove Worksheets("bracket sheet") and just do Range("B1").Validation.InputMessage, the InputMessage does generate as a Hover but on the player sheet in the correct cell. I need it to be on the bracket sheet. Help?

**Richard Buttrey** · 05-24-2022, 12:33 PM

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

I'm struggling to understand what YOU mean by a 'hover input message'.

**asaysamone** · 05-26-2022, 02:56 PM

Here's a more condense version of what I'm trying to do with just one sheet. I have a method that returns a set of ranges and I just want to loop thru the ranges and set the Validation.InputMessage to a value. In this case the text "Please work". It loops thru the first time fine but the second time, I get an error.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Validation.InputMessage Help

LinkBack

Thread Tools

Rate This Thread

Display

VBA Validation.InputMessage Help

Re: VBA Validation.InputMessage Help

Re: VBA Validation.InputMessage Help

Thread Information

Users Browsing this Thread

Similar Threads

VBA Data Validation - Multiple selections, each column has its own validation list

update data validation sources if validation values change

[SOLVED] Add inputmessage without removing existing data validation

Check if a cell has Validation.InputMessage

validation rules not working when someone copy paste data on validation cell

data validation-Can the source of the validation criteria be dfrom a different sheet?

Validation inputmessage multilines

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions