Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Run a macro in cell editing mode

  Asked By: Madeline    Date: Jan 18    Category: MS Office    Views: 1052
  

I want to select some part of the text of a cell and then run a macro.
Please help me how can I do it.

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Trae Thompson     Answered On: Jan 18

I don't think you can...............

 
Answer #2    Answered By: Rochelle Elliott     Answered On: Jan 18

You will have to include a inputbox within your code, get the range in the
inputbox and proceed.

for example :

your code........

Dim j As Variant
j = InputBox("Please enter the Range", "UserName")
Range(j).Value = 500

your code .......................

 
Didn't find what you were looking for? Find more on Run a macro in cell editing mode Or get search suggestion and latest updates.




Tagged: