ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a "sensitive regions" image on a form (https://www.excelbanter.com/excel-programming/361399-creating-sensitive-regions-image-form.html)

Zorro[_4_]

Creating a "sensitive regions" image on a form
 
Hi all
I would want to create a "sensitive regions" image on a form. For example,
it would be a european map where the user could select each country.
I know I could do it on a sheet using transparent shapes (one for each
country) on top of the image, but how could I do it on a UserForm?

Thank you



Harald Staff

Creating a "sensitive regions" image on a form
 
Hi

You can use labels, transparent without border and caption, and code their
mousedown, click and/or mouseup events. Or you could "simply" hardcode the
regions of the image; far more work, far less components. Here a simple NSWE
example:

Private Sub Image1_MouseUp(ByVal Button As Integer, _
ByVal Shift As Integer, _
ByVal X As Single, ByVal Y As Single)

Dim S As String

Select Case X
Case 0 To Image1.Width / 2
S = " WEST"
Case Else
S = " EAST"
End Select
Select Case Y
Case 0 To Image1.Height / 2
S = "NORTH " & S
Case Else
S = "SOUTH " & S
End Select

MsgBox S
End Sub

HTH. Best wishes Harald

"Zorro" skrev i melding
...
Hi all
I would want to create a "sensitive regions" image on a form. For example,
it would be a european map where the user could select each country.
I know I could do it on a sheet using transparent shapes (one for each
country) on top of the image, but how could I do it on a UserForm?

Thank you






All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com