Comments for Access Excel VBA

Comment on Illustrated Excel keyboard shortcuts by SowsStaskek

SowsStaskek — Thu, 08 Sep 2011 19:11:49 +0000

Earlier I thought differently, thanks for an explanation.

Comment on Illustrated Excel keyboard shortcuts by CootAbutt

CootAbutt — Mon, 05 Sep 2011 21:34:02 +0000

Unprejudiced making my blue ribbon mail at http://www.access-excel-vba.com, which seems to be a wonderful forum!

Comment on Error communicating with the OLE server or ActiveX Control by Zoltan Till

Zoltan Till — Mon, 22 Jun 2009 22:48:23 +0000

Danny: This can help also: http://www.utteraccess.com/forums/printthread.php?Board=83&main=1122452&type=post

Comment on Error communicating with the OLE server or ActiveX Control by Zoltan Till

Zoltan Till — Mon, 22 Jun 2009 22:45:19 +0000

Danny: Try to decompile: http://www.granite.ab.ca/access/decompile.htm

Comment on Error communicating with the OLE server or ActiveX Control by Danny

Danny — Mon, 22 Jun 2009 20:03:37 +0000

I get this error upon opening MS Access and tried both solution s previously listed but still no luck… Office XP sp3….. any thoughts?

Comment on Illustrated Excel keyboard shortcuts by Till Zoltán

Till Zoltán — Fri, 19 Jun 2009 06:52:08 +0000

Thanks Aurino, similar will come soon.

Comment on Illustrated Excel keyboard shortcuts by aurino

aurino — Fri, 19 Jun 2009 02:30:07 +0000

Nice tips … I love it … keep posting

Comment on Relative range names in practice by DEISKO

DEISKO — Wed, 13 May 2009 19:50:56 +0000

@Zoltan TillThnx… I will give it a try!

Comment on Relative range names in practice by Zoltan Till

Zoltan Till — Wed, 13 May 2009 14:17:39 +0000

Deisko, the solution for the dropdown validation is the Dynamic range names.For example:=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)You can read more about this here:http://www.dailydoseofexcel.com/archives/2004/06/30/dynamic-data-validation/This works without code too.

Comment on Relative range names in practice by DEISKO

DEISKO — Wed, 13 May 2009 14:03:47 +0000

Concerning “Relative range names in practice”; Can this somehow be used when a dropdown list (Data validation) is required?I tried to use it this way, but without positive result!Your answer is most apriciated.