ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using Visual Basic form to enter data (https://www.excelbanter.com/excel-programming/278266-using-visual-basic-form-enter-data.html)

Stephen Carpineta \(Matco Electric\)

Using Visual Basic form to enter data
 
Good morning/afternoon/evening all propspective help-
provders!

I am trying to create a visual basic UserForm that will
collect several pieces of data including many text
variables as well as an image, if possible. I want to
essentially use the "Data - Form" command, with
the "search by criteria' functionality, but with a form
that I've created in VB. So I guess this is a two
parter...

Is it possible, and if so, HOW, do I use a form that I've
created in place of the default form that "Data - Form"
gives you (all values lined up vertically.)

ALSO, is it possible, and if so how ;, do I embed an
image into a cell so that it may be viewed full-size upon
clicking it? Almost an "attachment," per se, present in
the cell but not viewable until activated?

Thanks so much for all your help,

Steve Carpineta

jaf

Using Visual Basic form to enter data
 
Hi Stephen,
Install the Template Wizard with Data Tracking.


John
johnf202 at hotmail dot com


"Stephen Carpineta (Matco Electric)" wrote in message
...
Good morning/afternoon/evening all propspective help-
provders!

I am trying to create a visual basic UserForm that will
collect several pieces of data including many text
variables as well as an image, if possible. I want to
essentially use the "Data - Form" command, with
the "search by criteria' functionality, but with a form
that I've created in VB. So I guess this is a two
parter...

Is it possible, and if so, HOW, do I use a form that I've
created in place of the default form that "Data - Form"
gives you (all values lined up vertically.)

ALSO, is it possible, and if so how ;, do I embed an
image into a cell so that it may be viewed full-size upon
clicking it? Almost an "attachment," per se, present in
the cell but not viewable until activated?

Thanks so much for all your help,

Steve Carpineta





All times are GMT +1. The time now is 05:10 AM.

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