Trouble working with VBA code in Microsoft excel 2010

Asked By ney steele 20 points N/A Posted on - 08/29/2012

Hi,

I’m having trouble working with VBA code in Microsoft excel 2010 version. I had developed an application using excel 2007 to enable dynamic controlling of the forms.

Like, by clicking a checkbox, some controls will be made visible, and some others will be rendered hidden. But in 2010 this code is giving me trouble. The position of the controls is getting altered. The code works well when line by line execution is carried out.

Please help me to fix this problem.

• Status: Open
• Question Views: 818
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Office

Answered By Mundo Villaro 0 points N/A #152736

Trouble working with VBA code in Microsoft excel 2010

Dear Ney Steele,

 

I can understand your problem. Microsoft excel 2010 is the new version of Microsoft excel. You have a problem with VBA code.

 

Please check your code again. If there is an error in developed code, some futures can be hidden. And if your computer working with the 32-bit ,you need to install 32-bit support  installation.And if 64-bit, you need to install 64-bit support installed. We recommend to buy the full version. If it is difficult , you can install a free version.

 

 

For more details:https://msdn.microsoft.com/en-us/library/office/ff700513(v=office.11).aspx

 

And if you can update your version ,it is more useful.I can strongly recommend to install 32-bit version of office 2010,because many common add-ins for office will not function in the 64-bit edition.

 

Note:

32-bit version of Office 2010 product users must have a 32-bit supported operating system on their PC.

64-bit version of Office 2010 product users must have a 64-bit supported operating system on their PC.

 

Good luck.

About Mundo Villaro

Questions
1

Answers
38

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 08/29/2012
• Question Category: Microsoft Office