Userform toolbox additional controls. F1.

[pedie]

Hi, I have never made used of Userform toolbox additional controls except for the Calendar. I wanna ask if someone can suggest me a link that will explain the additional controls that we have and how to use it and how it work etc.

Thanks for helping.
Pedie.

 

[Michael M]

Hi Pedie
A quick surf will get plenty of hits, but this one stands out.
Next option would be a search for a reference book targeting userforms

http://www.ozgrid.com/Excel/free-training/ExcelVBA2/excelvba2lesson3.htm

 

[pedie]

Michael, thanks and i'm going through right away

 

[VoG]

Hi Pedie.

I think that the available additional controls will depend on what software you have installed. For example, with recent versions of Office the Calendar Control is only available if you have a version of Office that includes Access, otherwise you need to download it.

 

[pedie]

Sorry Michael, i have seen this before i started this thread. It does not speak much about additional controls but the writer seems satisfied with the controls that we have without having to add/use additional controls. No doubt there is flexibilty but it does not give us enough information i guess.

But thanks again
Pedie

 

[pedie]

Hi Peter, sorry i didnt see your answer coming in. When i Userform toolbox additional controls i see lots of options which i'm not aware of what it can do so i was curious if there is any site which explains.

I have access included in this ms office package maybe thats y it has Calender then. What about other additional control? can you give me example of the use of few of these controls on what it does?

Thanks again.

 

[VoG]

Hi Pedie.

I can only suggest that you Google. One example is the Spreadsheet control that allows you to place an image of (part of) your sheet on the form. If you have Adobe (full version, not just the Reader) I'm pretty sure there are PDF options (can't check until work on Monday - groan!).

 

[pedie]

Link. I just did a searc on one of the additional controls that is WebBrowser1 of userform. and found this link.

 

[pedie]

Yea sure Peter i will do more googling today and tomorrow and then i'll come back with this topic on Monday.

Peter you have a great weekend!
Pedie.

 

[Michael M]

I guess another option, if you are going to get heavily involved.
Would be to have a look at Visual Studio