[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

Excel VBA Prompt to change named range value

Hello,

i need help with a VBA code that when my i run it, it prompts inputbox to ask me for a value and once i type value in inputbox that becomes the value for my named range "PercTT"

thanks.
0
Flora
Asked:
Flora
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

Sub Macro2()
    Res = InputBox("enter the PercTT value")
    ActiveWorkbook.Names("percTT").Value = "=" & Res
End Sub

Open in new window

Regards
0
 
FloraAuthor Commented:
thanks.

worked perfectly.

my question which is somehow related to this, is pending, appreciate if you could look into this too

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28599236.html
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now