Update cell value by Command button
Closed
issahamameh
Posts
22
Registration date
Friday October 19, 2012
Status
Member
Last seen
June 22, 2013
-
Oct 19, 2012 at 01:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 23, 2012 at 06:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 23, 2012 at 06:40 PM
Related:
- Excel button to change cell value
- How to change author in excel - Guide
- At button - Guide
- How to change date format in excel - Guide
- Change computer name cmd - Guide
- How to change idm language - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 19, 2012 at 06:00 PM
Oct 19, 2012 at 06:00 PM
I am bit confused here.
F2 key is supposed to make a cell ready for edits. So are you saying that you press F2, and then just type "f2" in the cell ?
F2 key is supposed to make a cell ready for edits. So are you saying that you press F2, and then just type "f2" in the cell ?
issahamameh
Posts
22
Registration date
Friday October 19, 2012
Status
Member
Last seen
June 22, 2013
1
Oct 20, 2012 at 01:33 AM
Oct 20, 2012 at 01:33 AM
Hi Rizvisa1,
Thanks a lot to your help.
I need a command button to make the process of pressing "F2" which is for edit as you said and then to press Enter. I don't want to change the cells contents. I'm doing this process to update the cell value format. For example if cell C3 content is (55555) and I change the format through "Customize" to be like this(55-555) so it will not take this effect unless I pressed F2 then enter.
Therefore, I don't need to fill or to type any thing, just pressing F2 then Enter.
This process I need it for this range (C3:C320).
Thank you in advance.
Thanks a lot to your help.
I need a command button to make the process of pressing "F2" which is for edit as you said and then to press Enter. I don't want to change the cells contents. I'm doing this process to update the cell value format. For example if cell C3 content is (55555) and I change the format through "Customize" to be like this(55-555) so it will not take this effect unless I pressed F2 then enter.
Therefore, I don't need to fill or to type any thing, just pressing F2 then Enter.
This process I need it for this range (C3:C320).
Thank you in advance.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 20, 2012 at 06:43 AM
Oct 20, 2012 at 06:43 AM
try this
1 Select range C3:C320
2. Goto to Data --> Text To Columns and click
3. In the wizard, select "Delimited" and press next
4. Unselect all check boxes and press next
5. select "General" and press finish
6. apply the format that you wanted
see if this works for u.
1 Select range C3:C320
2. Goto to Data --> Text To Columns and click
3. In the wizard, select "Delimited" and press next
4. Unselect all check boxes and press next
5. select "General" and press finish
6. apply the format that you wanted
see if this works for u.
Thanks a lot again rizvisa1,
I tried all the steps as mentioned, but the same result, I mean after I did all the steps, I copied and pasted values to the mentioned range (C3:C320 ) but it didn't took the defined formats, so for each cell I pressed "F2" then pressed "Enter" to take the defined formats.
Isn't there any code to do this process of "F2" then "Enter" for that list?
Thanks a lot,
Issa
I tried all the steps as mentioned, but the same result, I mean after I did all the steps, I copied and pasted values to the mentioned range (C3:C320 ) but it didn't took the defined formats, so for each cell I pressed "F2" then pressed "Enter" to take the defined formats.
Isn't there any code to do this process of "F2" then "Enter" for that list?
Thanks a lot,
Issa
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 22, 2012 at 05:27 PM
Oct 22, 2012 at 05:27 PM
Issa, could you please post a sample book with some sample data that has that issue. for ,me it worked. For posting book, choose as public file sharing site and post back the link to the file back here
thanks
thanks
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 23, 2012 at 06:40 PM
Oct 23, 2012 at 06:40 PM
Issa, try using speedyshare.com. You can upload file there. It will give you a link to the file, copy that link and paste it back here
