VB Forms  
Author Message
kster





PostPosted: Tue Aug 19 02:12:10 CDT 2003 Top

Excel Programming >> VB Forms

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.

Excel235  
 
 
Danny





PostPosted: Tue Aug 19 02:12:10 CDT 2003 Top

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



-----Original Message-----
>I don't see any need to use VB forms. You can use the=20
built in VBA
>Userform to display information: (many times, people say=20
VB and mean VBA
>and say Form and mean Userform - so perhaps this is what=20
was being
>suggested).
>
>http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
>Lesson 11: Creating a Custom Form
>Excerpted from Microsoft=AE Excel 97 Visual Basic=AE Step by=20
Step.
>
>http://support.microsoft.com/default.aspx?scid=3DKB;EN-
US;Q168067
>File Title: Microsoft(R) Visual Basic(R) for Applications=20
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=20
manipulating
>UserForms in Microsoft Excel 97. It includes examples and=20
Microsoft Visual
>Basic for Applications macros that show you how to take=20
advantage of the
>capabilities of UserForms and use each of the ActiveX=20
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=3D161514
>XL97: How to Use a UserForm for Entering Data
>
>http://support.microsoft.com/default.aspx?kbid=3D213749
>XL2000: How to Use a UserForm for Entering Data
>
>
>--=20
>Regards,
>Tom Ogilvy
>
>


>> 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=20
on
>> the screen which contains the data from a reference=20
point
>> on a worksheet i.e. A34:B76. I envisage this to work in=20
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=20
tutorial
>> on Forms in VB. I am fairly new to VB so please keep any
>> descriptions simple.
>>
>> Thanks in advance,
>>
>> Danny.
>
>
>.
>
 
 
Tom





PostPosted: Tue Aug 19 08:39:55 CDT 2003 Top

Excel Programming >> VB Forms 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



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
>
>


>> 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.
>
>
>.
>