Advanced VBA help

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Problem:

I have programmed an add-in to Excel in VBA, which can show you the formula and expression.

First a description:

We state an example:

A1 = 2, B1=2

And we want to sum this terms in C1, such that: =A1+B1 =4

Then I have made 2 options:

1. Default: So, if you mark cell C1: and push expression og formula you will get the formula/expression in D1.

2. Fixed column: Then you can mark C1: push expression and formula and you can choose which cell you want the result.

What my currently code cannot do, and what my problem is: if I hold let say: $A$1 and muliply it with B2 and want the result in C1. Yes I still get 4, but

the expression neither formula cannot show 2*2 or A1+B1. Instead it shows respectivly $A$1+2 and $A$1+$B$1.

In other words my code for expression and formula is not closed under absolutereference.

I need one who can give the last touch to this code so it wil work.

You can deal with it in the added Xlam file, and see a picture of the problem

Visual Basic

ID Проекту: #4479910

Про проект

4 заявок(-ки) Дистанційний проект Остання активність May 1, 2013

Доручено:

adim

Done! Please check inbox.

$45 USD за 1 день
(10 відгуків(-и))
4.1

4 фрілансерів(-и) готові виконати цю роботу у середньому за $65

djain01

Hi, Can we discuss. Thanks djain01

$110 USD за 3 дні(-в)
(47 відгуків(и))
5.3
Teloquence

Consider it done. Check your PM for my bid details.

$53 USD за 1 день
(9 відгуків(и))
3.6