Creating macro with question & answer function that updates sheet.

E

EdwinK

New Member
Joined
Mar 11, 2009
Messages
6
Need to create a macro that shows a menu to select from, which redirects you to a fill-in question box, the answer entered updates a cell in the workbook. If someone could get me started I’d greatly appreciate it.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

N
  • Question
Automating textbox updates in PP using VBA to read excel data
Replies
0
Views
446
noobslayer252
N
Kaz09
  • Question
Copy rows of data from multiple worksheets to based on column equalling YES
Replies
0
Views
109
Kaz09
Kaz09
N
  • Solved
Use different sheet names as part of a formula (indirect function?)
Replies
3
Views
303
awoohaw
awoohaw
I
  • Question
Show the "Edit Name" dialog from VBA for a specific Name
Replies
1
Views
364
Jaafar Tribak
Jaafar Tribak
R
  • Question
Functions with XLM macros are blocked
Replies
1
Views
165
MARK858
MARK858

Forum statistics

Threads
1,214,932
Messages
6,122,332
Members
449,077
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top