Macro Input Change From InputBox to Cell

**Gtrtim112** · 02-02-2019, 02:42 PM

I'm curious if the macro code below can be adjusted so that instead of a popup box being used for the parameter input, I can use a cell assignment instead.

Here is the current code. The spreadsheet contains a button that the user pushes and it prompts for the following information:

Please Login or Register  to view this content.

I would prefer that those 3 parameters be entered in cells J1, J2 & J3.

Is there a way to alter this macro code to allow for that?

Thanks!

**unit285** · 02-02-2019, 03:00 PM

This?

Please Login or Register  to view this content.

**Gtrtim112** · 02-02-2019, 03:40 PM

Originally Posted by unit285

This?

Please Login or Register  to view this content.

I didn't get an error changing it to that but it took my parameter inputs and changed them to zeros and didn't produce any results.

I had to rearrange it a little.... but got it to work

Thanks for pushing me in the right direction.

Please Login or Register  to view this content.

**unit285** · 02-03-2019, 01:46 AM

Glad u got it figured out

Macro Input Change From InputBox to Cell

LinkBack

Thread Tools

Rate This Thread

Display

Macro Input Change From InputBox to Cell

Re: Macro Input Change From InputBox to Cell

Re: Macro Input Change From InputBox to Cell

Re: Macro Input Change From InputBox to Cell

Thread Information

Users Browsing this Thread

Similar Threads

Date Picker, Required Cell input via InputBox, AutoUpdate Service Dates

Macro Reformatting Text Input on InputBox

Modify Macro to use InputBox Input Rather than harcoded value

Get input from user using application.inputbox. Input should be number and can be 0

[SOLVED] Change sheet name with Macro InputBox

[SOLVED] InputBox - If input has &, change & to ^&

InputBox-ow to have a user input text in a inputbox

Bookmarks

Bookmarks

Posting Permissions