excel - VBA Error Compile: Expected: Expression -


i working on homework , can't figure out why code won't work. assignment request name respond in red text in b10.

here code:

enter image description here

any great- thanks!

consider:

sub qwerty()     sheets("mynewsheet").activate     range("b10")         .font.colorindex = 3         strname = application.inputbox(prompt:="please enter name.", type:=2)         .value = strname     end end sub 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -