Search results for query: *

Thanks Bob!

I have figured a way to make use of the data by I'm having trouble making use of it later on, I guess I would need to declare it as a public variable but up until now I have only worked with private subs I declared it as public in a module but that didn't work, any suggestions? this is what I...

I would really appreciate some help right now, it's my first attempt at working with random numbers in VBA. I'm working in a "raffle" program who's end result should be employees inputting their employee number, which in turn will trigger a look-up for their name and hence a row number can be...

I declared it as range...is that ok?

Thanks Skip, I think figured out the issue although this only brought a lot more issues my way, I unknowingly wrote a code in 2003 vba for an excel 2000 user so I was able to adapt the code on most parts but I'm having issue with the following piece of code that's in another userform that...

Good Afternoon, I really need some help, I'm new to VBA and I've been working on this subtract/replace information userform, it is dependent of auto filters it's working fine in my computer and even in a different computer in the network when opened with my username however when a different...

Ok, so using len(vbNewLine) actually provides a value to line breaks, I will try it out with several exercises and see if this could work as a final resolution. Thanks for link UnsolvedCoding It was of huge help

Ok, so using len(vbNewLine) actually provides a value (character counting-wise)to line breaks, I will try it out with several exercises and see if this could work as a final resolution. Thanks for link UnsolvedCoding It was of huge help

Ok, so using len(vbNewLine) actually provides a value to line breaks, I will try it out with several exercises and see if this could work as a final resolution. Thanks for link UnsolvedCoding It was of huge help

Basically SkipVought what I want is since clicking on the notes filed auto places a time stamp the notes must contain: if it's an already worked account: something more than the previous notes and the time stamp. if it's the first time the account is being worked: something more than just the...

ok so I tried multiple thing but it's still not coming up as I wanted, I'm close but not there yet, I think I was making the problem more complicated than it was. Here's an explanation of what I'm doing. I have a user form on which inotes once being clicked will search the "inbound" sheet...

Thanks, let me try that.

Hi I was wondering if it was possible to obtain the value of a variable that was created/used on a different sub (0 as an example: --------------------------------------- Private Sub inotes_Enter() Sheets("inbound").Activate dim timestamp as string dim cnt as long timestamp = Format(Now, "mmm...

Excellent! Thanks so much that solved the issue! Man I need some lessons! Thanks again!

in that case I would just need it to create a time stamp on inots itself and then generate a space, as: if not rfound is nothing then 'found -- now do something else 'NOT FOUND -- inotes = timestamp + "" end if hope this helps clear up what I'm trying to do.

Thanks, that would be: ifind = Cells.find(what:=ian.Text, after:=ActiveCell) and the code wrks perfectly when I input an account that is already in the "inbound" sheet but not when imputing a new account.

Hi I'm new to VBA, I've been trying to fix the error I'm getting when creating a user form in excel, but I'm kind of stuck, the code is presented below. What the macro should do is, once I click on inotes.text it should automatically use the "ifind" variable to search through the sheet for the...

Hi I'm new to VBA, I've been trying to fix the error I'm getting when creating a user form in excel, but I'm kind of stuck, the code is presented below. What the macro should do is, once I click on inotes.text it should automatically use the "ifind" variable to search through the sheet for the...