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

Change the color of an oval at click in Java AWT -

c# - Unity IoC Lifetime per HttpRequest for UserStore -

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -