I have been told that a VB form may help to solve a
problem i am currently trying to get around in Excel.

I want a picture when clicked to open up a small window on
the screen which contains the data from a reference point
on a worksheet i.e. A34:B76. I envisage this to work in a
similar way to the sort of Javascript pop ups you see on
web pages.

Has anyone got any ideas on how to do this, or a tutorial
on Forms in VB. I am fairly new to VB so please keep any
descriptions simple.

Thanks in advance,

Danny.

I have used the VBA UserForm and can now display a form
which opens up when i click a picture and also has a close
button on it. How do i now get the form to display the
data from the worksheet i.e. A1:B24. I just want the form
to pick up certain data depending on which picture the
user selects.



-----Original Message-----
I don't see any need to use VB forms. You can use the
built in VBA
Userform to display information: (many times, people say
VB and mean VBA
and say Form and mean Userform - so perhaps this is what
was being
suggested).

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by
Step.

http://support.microsoft.com/default.aspx?scid=KB;EN-
US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications
Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to
manipulating
UserForms in Microsoft Excel 97. It includes examples and
Microsoft Visual
Basic for Applications macros that show you how to take
advantage of the
capabilities of UserForms and use each of the ActiveX
controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-
us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-
us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

These are about entering data, but are related:

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


--
Regards,
Tom Ogilvy


"Danny Sowden" wrote in message
...
I have been told that a VB form may help to solve a
problem i am currently trying to get around in Excel.

I want a picture when clicked to open up a small window
on
the screen which contains the data from a reference
point
on a worksheet i.e. A34:B76. I envisage this to work in
a
similar way to the sort of Javascript pop ups you see on
web pages.

Has anyone got any ideas on how to do this, or a
tutorial
on Forms in VB. I am fairly new to VB so please keep any
descriptions simple.

Thanks in advance,

Danny.


.

I would use a listbox - without more information, it would be hard to tell
you how to populate it conditionally.

basically

listbox1.Columncount = 2
listbox1.clear
for each cell in Range("A1:A24")
if ... some conditions ...
listbox1.additem cell.Value
listbox1.list(listbox1.listcount-1,1).Value = cell.offset(0,1).Value
end if
Next

--
Regards,
Tom Ogilvy

"Danny Sowden" wrote in message
...
I have used the VBA UserForm and can now display a form
which opens up when i click a picture and also has a close
button on it. How do i now get the form to display the
data from the worksheet i.e. A1:B24. I just want the form
to pick up certain data depending on which picture the
user selects.



-----Original Message-----
I don't see any need to use VB forms. You can use the
built in VBA
Userform to display information: (many times, people say
VB and mean VBA
and say Form and mean Userform - so perhaps this is what
was being
suggested).

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by
Step.

http://support.microsoft.com/default.aspx?scid=KB;EN-
US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications
Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to
manipulating
UserForms in Microsoft Excel 97. It includes examples and
Microsoft Visual
Basic for Applications macros that show you how to take
advantage of the
capabilities of UserForms and use each of the ActiveX
controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-
us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-
us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

These are about entering data, but are related:

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


--
Regards,
Tom Ogilvy


"Danny Sowden" wrote in message
...
I have been told that a VB form may help to solve a
problem i am currently trying to get around in Excel.

I want a picture when clicked to open up a small window
on
the screen which contains the data from a reference
point
on a worksheet i.e. A34:B76. I envisage this to work in
a
similar way to the sort of Javascript pop ups you see on
web pages.

Has anyone got any ideas on how to do this, or a
tutorial
on Forms in VB. I am fairly new to VB so please keep any
descriptions simple.

Thanks in advance,

Danny.


.