how to write code outside the VBE

[tony567]

hello, is it possible to write code line outside the VBE?

for example, i write msgbox("hello word") in cell A1 and then i press enter or push a command button and then excel do something like when i code msgbox("hello world")

>>>just imagine something like this

sub test()
excecute range("A1").text
end sub

thank you

 

[villy]

you have to create a custom function

 

[tony567]

you have to create a custom function

thanks for your respond villy, the above sample using msgbox is just an example.

it could be another routine that's not using msgbox

A1: range("B1").text = 1

sub test()
excecute range("A1").text
end sub

 

[RoryA]

You would have to have code that took the code in the cell and added it to a module, or if you really want to do that sort of thing, you could use the old XLM language and macro sheets. Can't imagine why you would want to, though.

 

[tony567]

You would have to have code that took the code in the cell and added it to a module, or if you really want to do that sort of thing, you could use the old XLM language and macro sheets. Can't imagine why you would want to, though.

thanks rorya,

mmmhh, any simple code to get me starting at this posibility?

 

[RoryA]

Lots here. Far more trouble than it's worth, IMO.