Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Matrix Table using Macros in Excel
#1
Hello People ,

I have a matrix with an option of giving the size of the matrix with a help of a resize button (Attached with this poost ) . But the table exhibits the follwing conditions

1). only 0 ,1 and 2 can be ebntered in the grren boxes of the table . for corresponding 0,1 and 2 the table automatically generates 2,1 and 0 in the grea boxes . it means if u enter 0 in the green box of the table, the table automatically generates 2 in the correspondoing oppsite grey box .

2). And for the header of the table , the names if u enter in the green rows the table automatically generates in the corresponding header in the grey columns .

My requirements in the table

1) I need the value to be entered only in the green boxes if someone tries to enter it in the grey box it should generate a meeasage saying that u cant enter values here .

2) If i click the resize button the previosuly entered values should be vanished .

3) Also I need the headers to be empty before starting the function .

How can I do that ? ........ I have attached the file with the post .
#2
Not all file types can be attached. Use zip.

But the question is probably not related to Quick Macros.


Forum Jump:


Users browsing this thread: 1 Guest(s)