Hi,
I have some experience with VBA but I'm new in VB6.
I'm looking for a way to include some Excel functionallity into VB forms: select multiple areas (like cells in Excel) by mouse-drag, assign a colour to them, translate the colours in values and store these values in a database. Once stored I must be able to call these values into the same form again.
The simplest way about this seems to insert part of an excel worksheet (50x10 cells) into a VB form and to be able to at least select the cells and colour them. Is this possible or does someone have a suggestion
[VB6] excel into vb forms?
flape
What your asking for is completely possible but these forums are for VB.NET and there are better places to find answers for older versions of VB such as VB6.
Maybe the VB6 newgroups - http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vb.general.discussion&lang=en&cr=US
or the VB6 resource center
http://msdn.microsoft.com/vbrun/
or web sites such as www.vbcity.com
You could however download VB Express and start working with .NET technology - its free to download from microsoft web site.
Hope these point you in the right direction.