• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Message box displaying cells name & values

R

Rodrigues

Member
Hi There
I'm working o a file with multiple cells, when users select either text or value on some of the cells, I would like a message box to display a message.
The file attached have a simple basic code, apart from what already displays if possible, would like to add to the message the heading and text and value selected cells.
Example:
T4 = YES
Message box: Please Action!
Test1
YES
----------------------
AI4 = 5
Message Box: Please Action!
Test6
5

Cells T4 & U4 - YES ; NO ; blank (display message only when YES is selected)
The others cells (highlighted at yellow) users will use values from 0 to ... (display message only when value selected is >0)

Message box trigger, when the cell user key in a text/value.
Thanks I advance
Regards
R
 

Attachments

Narayank
I'm sorry to disturb you, tried on Book1(1) does work fine, when test it on my file return run time error424 and highlight
Code: 
If Application.Intersect(Target, [DataEntryCells]) Is Nothing Then
, will it make a difference other cells I have on the file with different data?
Could you please help/advise?
Thanks
R
 
Hi ,

That is because DataEntryCells is a named range which is defined in the file I uploaded ; you will have to create this named range in your file.

Select T4 ; keeping the CTRL key pressed , click on all the other data entry cells such as U4 , AI4 ,... ; once all the data entry cells are selected , click on the Name Manager , New and enter the name DataEntryCells.

Narayan
 
Hi ,

The named range DataEntryCells can include as many cells as you want ; you will have to select each range of cells ; suppose you want to enter data in the rows 4 through 200 , then select the range T4:T200 , then keeping the CTRL key pressed , select U4:U200 , AI4:AI200 and so on.

Narayan
 
You must log in or register to reply here.
Back
Top