Random numbers generator

**Eric Excels** · 09-12-2011, 07:05 PM

Hey there,

Could anyone be of any help in developing some sort of Excel add-in (.xlam) which when activated/clicked from its shortcut on a workbook/worksheet would help in automating the task of typing/generating random numbers onto columns/rows? Here’s how it should specifically function:

From within the code itself in VBA, there would be the following below variables which I could go into and edit, then save and whenever needed I would click the add-in shortcut on my Quick Access Toolbar to have it apply my pre-saved/pre-set variable settings as random generated numbers into the selected columns/rows….

*Prefix if any [(here between those two brackets or whatever you want to use I would input any prefix if I have one, which could be anything, such as a number, a symbol, a letter, etc, and leaving it blank would simply mean there are no pre-fixes to apply)]

*Number length [(this one I would put something like 3 for example, which means all the random generated numbers would all have their length as 3 random numbers such as 564, or 675, etc, and like all the other options, if left blank this one would mean there are no numbers to generate)]

*Numbers in-between ?&? [(this one simply means I could for example put something like 100-200, and this would mean that the generated numbers can only be between 100 and 200 or for example between 100,000 and 200,000 for a bigger example, and exactly like the two other ones, if left blank it would mean this function is not to apply as well)]

That’s all there is to it, I guess pretty simple but I’m not really capable of doing it. So we’d want that to work as an add-in as specified above, and also one other thing is we’d want all the numbers we generate to actually be inputted as if they were typed into the columns/rows, meaning if I ever needed to check into the formula bar there would be no formula for the numbers, it would just be plain numbers, all the functions/formulas/etc would only be applied just for the add-in to work, but the generated numbers should all be simple plain numbers whenever/if checked with the formula bar, they wouldn't be the result of a formula or anything else except the generated number.

If anything wasn’t clear do not hesitate to let me know and I’ll make sure to clarify things, all and any help is greatly appreciated.

Thanks,
Eric

**Eric Excels** · 09-13-2011, 08:14 PM

Bump -- no thoughts on this guys?

Thanks,
Eric

**shg** · 09-13-2011, 08:26 PM

Eric, in all kindness, we're here to help people, not be a service bureau for turnkey applications.

Why don't you get started on it, and post a specific question when you get stuck?

**Eric Excels** · 09-13-2011, 08:34 PM

Hi shg,

Thanks for the reply, in all honesty the only issue is I really don't know how to code in VBA....I've been able for a time or two to add some code that was provided to me to an already working module of an add-in after playing a bit around with it, but apart from that, I pretty much don't know anything as far as Excel coding goes.

Any chance you can help me out with this?

I just find that the help I've been provided on this forum thus far has been amazing, and the little macros/add-ins members as well as moderators on here have generously provided have literally saved me hours upon hours of repetitive, tedious (sometimes even impossible) Excel work...but I wouldn't even be sure how to code the simplest of Excel macros to be honest.

Hope this isn't too much of an issue

**shg** · 09-13-2011, 10:10 PM

It's no issue at all, you're welcome to ask for whatever you like. I was just explaining the silence.

**Eric Excels** · 09-14-2011, 08:49 AM

Alright thanks, so do you think you can help me out with this? Or anyone else who might know how for that matter?

Really I didn't want to make it seem as this would be an application or anything, it's just going to be some code in an add-in format which is why I said above to keep everything contained within the code where I could go and edit the options by myself, this way it's be easier for the person developing it and wouldn't require any UserForm, etc.

Anyways, if anyone can try and share some knowledge/help on doing this, it'd be really appreciated.

Thanks guys,
Eric