Quick question on VB code
Solved/Closed
Related:
- Quick question on VB code
- Battery reset code - Guide
- Quick cpu - Download - Diagnosis and monitoring
- Samsung volume increase code - Guide
- How to get whatsapp verification code online - Guide
- Cs 1.6 code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 11, 2011 at 09:39 AM
Apr 11, 2011 at 09:39 AM
Hello Weenie,
Having trouble understanding you.
You want to input a value in column B using an inputbox based on the value in column C.
To do this, you just enter a value in B2, hit enter, enter next value and so on.... Or remove the last two code lines if you want to use the inputbox.
I'm clearly missing something.
Can you re-explain your issue with maybe an example of how you sheet looks like or even post your workbook using a site like www.speedyshare.com.
Best regards,
Trowa
Having trouble understanding you.
You want to input a value in column B using an inputbox based on the value in column C.
To do this, you just enter a value in B2, hit enter, enter next value and so on.... Or remove the last two code lines if you want to use the inputbox.
I'm clearly missing something.
Can you re-explain your issue with maybe an example of how you sheet looks like or even post your workbook using a site like www.speedyshare.com.
Best regards,
Trowa
Apr 11, 2011 at 10:26 AM
Order Type Name Values
Dog -432
Horse 3223
pig 332
owl -0.23
cat 1.2
rat 0.546
lion 0.47749
zebra 0.4321
sheep 0.6576
cow 3.756
tiger 70
fish 76
ant 45
rhino 32
beetle 21
Basically, after copying the name/values from another sheet, I have input box asking to enter the "type" and using the "Name" column to autofill to lastrow. It works initially BUT my problem is I am copying "Name/Values" in increments and prompting input box each time since "Type & Order" will be different. Example, I brought in data under "Name/Values" up to 'Lion' and input box asks me to enter "Type" and I enter, 'Home'. Then I bring in next batch data of "Name/Values" (will be placed after 'Lion') and now prompt input box for "Type" & enter 'Bus' and want it to autofill/copy to the last row in Name which would be beetle. What is happening when i bring in this second set, is it replaces everything in "Type" I entered previously. Hope this helps and thanks for responding. I'm at a loss how to fix this.
Thanks,
weenie
Apr 12, 2011 at 09:32 AM
Don't know what you uploaded (some sort of zip file?), but your story made your query clear to me.
Try this code:
Does this work for you?
Best regards,
Trowa
May 5, 2011 at 02:46 PM
Thanks,
weenie